I have a MS SQL client (SQL4, IP = x.x.x.154); this is a cluster client. 
Over the weekend my DBAs migrated all it's functions over to a new name 
(SQL 5, with the same IP x.x.x.154). I want to verify what I need to do 
...

Save the client ID of the SQL4 client
Delete the SQL4 client
Create a new client SQL5, with the same IP *and* the same client ID as 
SQL4
(that should save all the history of SQL4, but it will be accessible as 
the new name SQL5)

Possible wrinkle: there used to be a separate client called SQL5 (not sure 
of the IP), which had a different client ID ...

The DNS name is now SQL5, BTW - SQL4 doesn't actually exist anywhere ...

That should all Just Work, creating a new SQL5 with SQL4's client ID, in 
order to keep all the history available, and the fact that there was a 
previous client with the same name (SQL5) should be immaterial, as the 
client IDs  are completely different. Correct?

-- 
Michael Leone
Network Administrator, ISM
Philadelphia Housing Authority
2500 Jackson St
Philadelphia, PA 19145
Tel:  215-684-4180
Cell: 215-252-0143
<mailto:michael.leone AT pha.phila DOT gov>

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER