April 30, 2008 at 2:57 am
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
April 30, 2008 at 3:20 am
Solved the issue 😀
April 30, 2008 at 4:30 am
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.
April 30, 2008 at 4:32 am
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.
April 30, 2008 at 7:55 am
Ratheesh.K.Nair (4/30/2008)
Solved the issue 😀
How 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