There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
ASSP.DiscoverXmlMetadataFull : Try to store result into table
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