delete server name
-
Hi,
I have added server name using sp_addserver.but am not able to see the names using select @@servername.Now how can i delete those names which i added.When queried using select * from sys.sysservers am able see those name.
TIA
-
Solved the issue
-
use the following script to check the servers added -
select *
from sys.servers
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit. -
you can use sp_dropserver to remove the servers already added.
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit. -
Ratheesh.K.Nair (4/30/2008)
Solved the issueHow did you solve this issue?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply