August 25, 2015 at 11:48 pm
Hi All,
I am executing one SP in 2010 and 2012.
[In SQL server 2010 it is executing properly and getting result.
In SQL server 2012 it is executing improperly and getting some Errors. Below are some Execution related details.
The metadata could not be determined because statement 'EXEC sp_xml_preparedocument @docHandle OUTPUT, @xmlDocument' in procedure invokes an extended stored procedure.
Please Help me anyone
Thanks in advanced
Rambabu
August 26, 2015 at 12:55 am
Quick question, can you post the code for the procedure Abc.DBO.aspRoleFCUD?
😎
August 26, 2015 at 1:42 am
The metadata could not be determined because statement 'EXEC sp_xml_preparedocument @docHandle OUTPUT, @xmlDocument' in procedure 'aspRoleFCUD' invokes an extended stored procedure.
This is a well known issue. In SQL Server 2012 something has changed regarding the way metadata is gathered. Extended stored procedures don't support metadata discovery any more.
If you are querying the results of the invocation of a stored procedure with OPENROWSET, you will have to stage the results to a temp table first, then query the temp table.
-- Gianluca Sartori
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply