Saturday, February 10, 2018

Linked Servers - How to find connection details - data source of linked server Name


Run


select * from sys.servers


Output looks like below

server_id
name
product
provider
data_source
0
ODSSIT\ODSSIT
SQL Server
SQLNCLI
ODSSIT\ODSSIT
2
EDW_ESB
SQL
SQLNCLI
DWHSIT\DWHSIT
3
EDW
SQL
SQLNCLI
DWHSIT\DWHSIT

Recently Executed queries

 SELECT     txt.TEXT AS [SQL Statement],     qs.EXECUTION_COUNT [No. Times Executed],     qs.LAST_EXECUTION_TIME AS [Last Time Executed],   ...