Jon,

thanks for your quick response and clarifying things.

Cheers

Murali

Hello Guys,

I am trying to run one of the scripts to capture the Deadlock info. I could not get a working version .

select CAST(XEventData.XEvent.value('(data/value)[1]', 'varchar(max)')

as xml) as DeadlockGraph

FROM

(select...

No luck mate

Hi ,

I am using the following code :

DECLARE @DBNAME VARCHAR(128)

DECLARE DBLIST_CURSOR CURSOR FOR

SELECT NAME FROM sys.databases WHere name not in ( 'msdb','master','model','tempdb')

OPEN DBLIST_CURSOR

FETCH NEXT FROM DBLIST_CURSOR INTO...

Hi Adam ,

I am working on the same requirement and having the same error

"'CREATE TRIGGER' must be the first statement in a query batch."

I appreciate if you could...

http://www.sqlservercentral.com/articles/powershell/65196/

Hi

I tried the following and seems to be working. You can tweak the code for your requirement , need to change the servername , databasename, tablename. I picked this...

Hi Jordan ,

Even I am having the same issue , I am getting this error on SQL SERVER 2008 R2 . I have looked into the fix URL ....