Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Change @@servername in SQL 2005 Expand / Collapse
Author
Message
Posted Thursday, February 19, 2009 8:46 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 1, 2014 1:26 PM
Points: 2,242, Visits: 3,645
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
Posted Thursday, February 19, 2009 8:48 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 22, 2014 4:56 AM
Points: 1,093, Visits: 2,617
yup... realized that... see my previous post...



_______________________________________________________________________
For better assistance in answering your questions, click here
Post #660452
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse