Activity overview
Latest activity by ayesamson
I ran into the same thing. Then I changed the query type to DMX (File --> New --> Analysis Services DMX Query) and the following query ran just fine.
SELECT * from $system.DBSCHEMA_CATALOGS
If you are looking to get specific columns encase them within []
SELECT [CATALOG_NAME] from $system.DBSCHEMA_CATALOGS
If you're looking to run this via OPENQUERY locally I read that you'll need to enable Data Access
exec sp_serveroption @SERVERNAME, @optname = 'DATA ACCESS' ,@optvalue = 'TRUE'
Then you should be able to run the following statement.
SELECT * FROM OPENQUERY(<YourServerName>, 'SELECT [CATALOG_NAME] FROM $system.DBSCHEMA_CATALOGS')
I have only done so with a linkedserver. / comments
I ran into the same thing. Then I changed the query type to DMX (File --> New --> Analysis Services DMX Query) and the following query ran just fine.
SELECT * from $system.DBSCHEMA_CATALOGS
If you ...