Skip to main content

When you create a linked server in SSMS, the System Tables are not available in the table/view listing, but they can still be accessed and queried.  

 

To query the System Tables, you will be using the OPENQUERY call, like the example below:  
 
SELECT * FROM OPENQUERY(NLinked Server Name], 'SELECT * FROM sys_tables'); 

 

If you have additional questions or need any assistance, please reach out to [email protected] for further help