var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: linked server
I have a programm that create linked server on start of application and delete it on finish.
I need to check if linked server already exist on my server.
How can i do it?
system catalog: SYSSERVERS
The easy way would be to check the return code from sp_addlinkedserver.
Assuming you have a server called "goroddServer"
if exists (select srvname from master.dbo.sysservers where srvname = goroddServer)
print 'goroddServer already exists and is dropped'
exec sp_dropserver goroddServer
You may not want the print statement but I have it in for debugging purposes
Hope this helps