Thanks.

I had to make a few tweaks to get that to work, but I got it working. Thanks again!

[font="Courier New"]if exists(select * from master.dbo.sysservers where srvname='MyLinkedServer')

BEGIN

exec sp_dropserver 'MyLinkedServer','DropLogins'

END

GO[/font]

Thank you Lowell, that was very helpful.

This SQL is going to be run periodically, I think I will create the linked server, do my stuff, and then disconnect it. ...