kinton
asked on
How do I execute some XMLA from inside a Stored proc (exec(@xml) doesnt work)
I have a stored procedure which builds some XMLA statements to create some roles.
The statements get stored in the @xml varchar variable. I was hoping I could run exec (@xml) like I would normally do with SQL but that doesnt work. Any idea how I run them?
Any help would be much appreciated.
Regards,
Kinton
The statements get stored in the @xml varchar variable. I was hoping I could run exec (@xml) like I would normally do with SQL but that doesnt work. Any idea how I run them?
Any help would be much appreciated.
Regards,
Kinton
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Regards,
Kinton