Raport linked servers

Configurare noua (How To)

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

Tip solutie

Permanent
Etichetare:

Voteaza

(19 din 37 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?