Posted by mednyk on 06/01/06 18:19

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.

Or maybe there are other problems that have to be solved before.
Thank you

• Next in forum: Re: T-SQL Debugger Doesn't Allow Stepping Through Stored Procedures no other procedure with the same name
• Prev in forum: listing all SQL SErver and fill a sheet
• Thread view: Re: T-SQL Debugger Doesn't Allow Stepping Through Stored Procedures no other procedure with the same name

[Reply to this message]