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 |
|
maagt
Starting Member
20 Posts |
 Posted - 2008-11-03 : 21:14:34
|
| Hi there,can anyone advise me how to drop a linked server and anything i need to do before dropping the link??Thanks. |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-11-03 : 22:52:53
|
| This example removes the remote server servername and all associated remote logins from the local SQL Server.sp_dropserver 'servername', 'droplogins' |
 |
|
|
maagt
Starting Member
20 Posts |
Posted - 2008-11-03 : 23:19:39
|
thanks Saurab...at first, i thought 'droplogins' is referring to sqluse but it actually referred to the remote logins. thanks ya!!  |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-11-04 : 11:12:49
|
| You're Welcome |
|
|
|
|
|
|
drop linked server