如何在sp_addlinkedserver之前判断dbserver已经在sysservers中存在

if(dbserver is in sysservers)
else
EXEC sp_addlinkedserver @server = 'dbserver'

请教如何实现?
---------------------------------------------------------------

if exists(select * from sysservers where srvname='sqlsrv03')
begin
print 'ok'
end
else
EXEC sp_addlinkedserver @server = 'dbserver'

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus