Jun 18, 2010 at 7:54 AM
Edited Jun 18, 2010 at 7:55 AM
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