December 23, 2004 at 11:26 am
Is it possible to change the name of an installed instance. I have SQL2000 installed on my development machine as an unnamed default instance. The production version of the database is installed as a named instance. This is causing headaches as I am constantly forgetting to add the instance name to scripts I create and test locally but then need to push out to production. If I could easily change my unnamed default instance to a name instance, it would make my life a bit easier.
Gordon Pollokoff
"Wile E. is my reality, Bugs Bunny is my goal" - Chuck Jones
December 23, 2004 at 1:40 pm
You can use sp_dropserver and sp_addserver to change the name. But if you have jobs, DTS and stored procedures that reference the old name, then you need to change them as well.
To see the name of server, type: sp_helpserver
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply