Viewing 3 posts - 1 through 3 (of 3 total)
it is possible to rename the named instance of SQL server 2K, first use sp_dropserver and sp_addserver (drop the old server name and add new server name in sysservers table)....
March 16, 2005 at 12:41 pm
#547351
Thanks Amit,
but I'am unable to understand, why my query is not working..what might be wrong with it
April 6, 2004 at 6:15 am
#501846
After sp_dropserver sp_addserver you have to restart the sql server for that global variable @@ServerName to take effect.
March 1, 2004 at 1:37 am
#496397