@jfogel

can you explain in detail how you unregister and reregister the dll files.. and which dll files did u register?

i am trying your SP and it's not deleting the old file..

can you explain in detail if have to setup differently?

Thanks

Did you able to solve this problem..i am working with this problem so let me know if you have solution

thanks

Nice Script .

thanks for posting here...

You can find out from error log(sp_readerrorlog) if the TRACE FLAG 1204 or 1222 was on.

here you can find detail

http://colleenmorrow.com/2011/03/01/deadlocks-and-trace-flag-1204/

Ya i found this file .. so can you explain me whats mean of re-register please?

its SQl Server 2008 (100)

this is good task ..what we needed for to transfer files remotely..

thanks for nice post

Says Access Denied..

found nice article and tool here

http://www.mssqltips.com/sqlservertip/2369/using-extended-events-to-troubleshoot-sql-server-issues/

thanks for kind guidance...

I have put this script on prod environment and working fine giving me nice alert in e-mail.

But some time when i check error log and i found the deadlock...

This is nice article..

when i tried to implement the Enlist and Ensure process doesn't work. so do i have to make any security changes ?

This is script of my first step of Job .

INSERT INTO BLOCKED_PROCESS_REPORT (

[PostTime] ,

[SQLInstance] ,

[Databaseid] ,

[computerName],

[SessionLoginName],

[SPID] ,

[TransactionID] ,

[EventSequence] ,

[objectID] ,

[IndexID] ,

[TextData],

[duration]

)

VALUES (

GETDATE(),

N'$(ESCAPE_NONE(WMI(SQLInstance)))',

N'$(ESCAPE_NONE(WMI(Databaseid)))',

N'$(ESCAPE_NONE(WMI(ComputerName)))',

N'$(ESCAPE_NONE(WMI(SessionLoginname)))',

N'$(ESCAPE_NONE(WMI(SPID)))',

N'$(ESCAPE_NONE(WMI(TransactionID)))',

N'$(ESCAPE_NONE(WMI(EventSequence)))',

N'$(ESCAPE_NONE(WMI(objectid)))',

N'$(ESCAPE_NONE(WMI(indexid)))',

N'$(ESCAPE_SQUOTE(WMI(Textdata)))',

N'$(ESCAPE_NONE(WMI(Duration)))'

)

I tried but i am not getting any alert when i create the DB.