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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2003-07-07 : 05:53:06
|
| Hello ,I had setup a linked server for testing purpose to test the distributed queries with remote logins . Now that my testing is over , i want to remove it . I removed the the remote logins as per BOL but still when I goto my EM right click and select delete the server , it says :cannot drop server ' server name 'because it is used as a distributer for replication . How do i connect to the distributer and remove the server ? Can you pl. help ???Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-07 : 13:51:33
|
| The error that you are receiving indicates that you have setup replication and that replication is still using the linked server. You will need to first drop replication, then remove the linked server.Tara |
 |
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2003-07-07 : 21:40:45
|
| Hi ,Thanks for your reply . I have in fact not setup any replication , but only linked servers , which i wish to remove . I am surprised at this message . I thought that after configuring Linked servers , removing them would be a straight forward task as it looks when referred to BOL .But I don't know why it is giving me this message . Is this server entry logged somewhere on other servers where it is linked . I am stuck badly .......Thanks . |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-07-08 : 10:17:14
|
What happens when you try it in QA instead of EM.sp_dropserver @server 'servername', @droplogins = 'droplogins' Jeff Banschbach, MCDBA |
|
|
|
|
|
|
Remove Linked server.