Situatie
Mai jos aveti o procedura ce intoarce date despre toate serverele definite pe un server de sql (de tipul linked server).
Solutie
create procedure BD_GetAllLinkedServers_prc
as
SELECT a.NAME,a.product,a.provider,a.data_source,a.catalog ,
f.[name],b.[uses_self_credential],b.[remote_name] FROM sys.[linked_logins] AS b
right JOIN sys.servers AS a
ON a.[server_id]=b.[server_id]
left JOIN sys.[server_principals] AS f
ON b.[local_principal_id]=f.[principal_id]
order by 1
Leave A Comment?