Extract DMVs from MS SQL Server

1

Hi EasyMorph Community,

I’m trying to extract system views from an MS SQL Server DB (version 2008). I tried it with the native connector and via a generic ODBC connection. In both cases, the connector won’t let me access the DMVs. I removed blacklist restrictions on the native connector (they seem to be set by default), but I still cannot see the views. I do have access rights to the views and can see them via SSMS.

Would someone happen to know a way to extract the system views?

Thanks in advance!

Best,
Albert

2

Just managed to find the solution. Executing a custom sql command works!

1 Like