Posted by Erland Sommarskog on 06/01/06 21:02

(mednyk@hotmail.com) writes:
> Hello,
> You were right:
> select @@Servername
> returns null
> Finally I was added to sysadmin group on sql server I tried to run
> sp_addserver 'IT456', 'local'
> And I got
> Server: Msg 15028, Level 16, State 1, Procedure sp_addserver, Line 14
> The server 'IT456' already exists.
>
> I know I can use 'duplicate_OK' or sp_dropserver and recreate it, but
> I don't know what implications can be.
> It is important server so I cannot "play" with it.

The implications as such are harmless. However, for it to take effect
so that @@servername is no longer NULL, you need to restart SQL Server,
which may not be acceptable.

Then again, if this is a production server, you should not run the
debugger on it anyway.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: How can I conserve the initial zero when convert numeric to string using STR()
• Prev in forum: Re: money data type
• Thread view: Re: T-SQL Debugger Doesn't Allow Stepping Through Stored Procedures no other procedure with the same name

[Reply to this message]