Having looked around on the net, some of the 3rd party tools are supposed to do what I am looking for especially with all the compliance regulatory. You will...

Thanks for the reply. I guess it will have to be a third party since DBAs at my place have sysadmin rights and they can disable Extended events. ...

SQL 2008 Sp1

I've tried it on another instance, it works. Very strange as both instances are set up the same?

Thanks for this but my developers are getting frustrated as they can't seem to do this via ssms gui. No errors

Thanks again. I shall have a little play around.

Hi thanks.

I am assuming if I change the -2 to -1 it will be leaving just 1 month of data behind?

Thanks

Yep for a particular db.

Lowell,

Fantastic and light faster.

Thanks,

I don't know the structure at all, and the other team wanted me to do a general search on the database and try to catch the word for e.g. test....

Thanks

I'm not really able to do much since this is a third party product which is frustrating! I would have thought that perhaps I might have been able to...

Hi,

As this is a third party app, the guys are accessing this through the GUI and the app just freezes!

Gail,

I get an error when I run the example you've given.