Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Linkserver history

Author  Topic 

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-06-18 : 09:40:31

Hi Gurus,

How can i get linkserver history as when was link server created, lastmodified datae...etc...


Thanks,
ServerTeam

sqldba20
Posting Yak Master

183 Posts

Posted - 2008-06-18 : 11:19:26
select * from master..sysservers

OR

select * from sys.servers
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-18 : 11:46:03
And if you need properties of all linked server ,you can use

sp_linkedservers
Go to Top of Page
   

- Advertisement -