This project has moved and is read-only. For the latest updates, please go here.

ASSP.DiscoverXmlMetadataFull : Try to store result into table

Topics: Developer Forum, User Forum
Jun 18, 2010 at 8:54 AM
Edited Jun 18, 2010 at 8:55 AM

Hello...

in order to synchronize cube from a source server i d like to check in a sqlserver job if olap db are procssed on source server. with this code ...

SELECT * into  #TEMP_STATE FROM

openrowset('MSOLAP', 'DATASOURCE=localhost;Initial Catalog=OLAP','CALL ASSP.DiscoverXmlMetadataFull("Database");' )  

I get this error :

Msg 7357, Level 16, State 2, Line 2Cannot process the object "CALL ASSP.DiscoverXmlMetadataFull("\Databases\Database") ". The OLE DB provider "MSOLAP" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object.

 

Other execution like this one works fine...

SELECT * into  #TEMP_LOCK FROM

openrowset('MSOLAP', 'DATASOURCE=localhost;Initial Catalog=OLAP','CALL ASSP.Discover("DISCOVER_LOCKS");' ) 

someone have a workaround to realize such a check ? Thank you

 

 

Jun 21, 2010 at 3:51 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.