lklein (5/8/2008)
This is so frustrating... yikes - I get an error running that just in design view right?
Yes, the RaisError raises an error. In Preview mode, you'll see the xml line that you're passing to the procedure.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes