Change @@servername in SQL 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Change @@servername in SQL 2005

12 posts, Page 2 of 2

««1 2

Change @@servername in SQL 2005

Rate Topic

Display Mode

Topic Options

Author

Message

ps.

Posted Thursday, February 19, 2009 8:46 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 02, 2013 2:32 AM
Points: 2,236, Visits: 3,620

Richard M (2/19/2009)

um....
sp_dropserver will "remove a server from the list of known remote and linked servers on the local instance of SQL Server"..... so it will not affect at all your running instance.

when you run sp_helpserver you are getting production right?

Not sure if only the sp_addserver with the 'local' option will do the trick

You can change the Servername using sp_addserver.
Refer http://msdn.microsoft.com/en-us/library/ms143799.aspx?ppud=4

Pradeep Singh

Post #660449

Richard M.

Posted Thursday, February 19, 2009 8:48 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 1,058, Visits: 2,575

yup... realized that... see my previous post...

_______________________________________________________________________
For better assistance in answering your questions, click here

Post #660452

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions