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.