Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
 Posted - 2005-02-14 : 13:36:33
|
I ran sp_dropserver 'xyz' quote:
error message:Server: Msg 15190, Level 16, State 1, Procedure sp_dropserver, Line 44There are still remote logins for the server xyz
So I ran sp_helpremotelogin 'xyz' quote:
error message:Server: Msg 15201, Level 16, State 1, Procedure sp_helpremotelogin, Line 20There are no remote logins for the remote server 'xyz'
What am I missing? www.zombo.com |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2005-02-16 : 05:49:20
|
corrupt tables, may be...not sure..have you tried sp_dropserver 'xyz', 'droplogins' Hemanth GorijalaExchange a Dollar, we still have ONE each._______Exchange an Idea, we both have TWO each. |
 |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2005-02-16 : 13:59:48
|
| That worked great thank you, not sure how I missed that option in BOLYou can do anything at www.zombo.com |
|
|
|
|
|
|
Drop remote server