sp_linkedservers_rowset2 (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_linkedservers_rowset2()

MetaData:

   
create procedure sys.sp_linkedservers_rowset2  
as  
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -  
--  copy & pasted from version 1 of the SProc and removed checks for 1st parameter !  
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -  
    select  
        SVR_NAME            = s_s.name,  
        SVR_PRODUCT         = s_s.product,  
        SVR_PROVIDERNAME    = s_s.provider,  
        SVR_DATASOURCE      = s_s.data_source,  
        SVR_PROVIDERSTRING  = s_s.provider_string,  
        SVR_LOCATION        = s_s.location,  
        SVR_CATALOG         = s_s.catalog  
    from  
        sys.servers s_s  
    where  
        --  Don't use s_s.is_linked, because 0 there means old-style linked server, 1 means new-style.  
        s_s.is_data_access_enabled = 1  
    order by 1