dinsdag 25 november 2008

how to check if linked server exists

how to check if linked server exists in SQL Server 2000:
--------------------------------------------------------
Select 1 Where Exists (Select [SRVID] From master..sysservers Where [srvName]='PSQLWEB1')


how to check if linked server exists in SQL Server 2005:
--------------------------------------------------------

Select 1 Where Exists (Select [SERVER_ID] From sys.servers Where [Name]='PSQLWEB1')

Geen opmerkingen:

Een reactie posten