September 4, 2009 at 7:22 am
I run the following code:
exec sp_dropserver @server = 'scorpious'
However, I get the following error:
Server: Msg 15190, Level 16, State 1, Procedure sp_dropserver, Line 44
There are still remote logins for the server 'scorpious'.
When I look in sysremotelogins, there are no records.
I also run: execute sp_helpRemoteLogin and get:
Server: Msg 15200, Level 16, State 1, Procedure sp_helpremotelogin, Line 16
There are no remote servers defined.
I'm not sure where to look to find the remote logins that won't allow me to drop the local server.
September 4, 2009 at 7:58 am
Are there connections open by any chance?
Linked servers?
September 4, 2009 at 9:56 am
no linked servers and no other connections open other than myself
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply