Viewing 4 posts - 1 through 4 (of 4 total)
opc.three (7/3/2012)
This sounds like a bug thathas been fixed. What build of SQL Server are you on?Connect Item: Invalid XML in Extended Events xml_deadlock_report output by Jonathan Kehayias
I am...
July 13, 2012 at 4:44 pm
I figured it out...why the sample code is not doing it the same I don't get...
here is the fix:
The file has to start and end with a
<deadlock-list>
</deadlock-list>
Tag.
Then it needs...
June 29, 2012 at 6:01 pm
I figured it out...works like a charm
SET XACT_ABORT ON;
BEGIN TRY
-- refresh the stored procedure
...
June 20, 2012 at 4:09 pm
While this works great when views are valid it crashes the proc if a view won't refresh correctly.
It seems to be fine when running this with the sp_refreshsqlmodule on...
June 20, 2012 at 12:53 pm
Viewing 4 posts - 1 through 4 (of 4 total)