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')
Abonneren op:
Reacties posten (Atom)
Geen opmerkingen:
Een reactie posten