Thanks all for the replies. It's amazing how explaining something to someone (or a forum!) helps you to see the wood for the trees!

Looking at the explain plan and...

Hmm, that is strange. I've run your code and get null for the sql part.

Anyway, it's doing what I need for now. If I have some more time, then I...

Thanks again for the reply. I tried your code but still couldn't get the sql to display. By retriveing the whole event data and looking at the event instance...

Thanks for this. I was setting @data to the eventdata(), but I just cleared that bit out of my example code by accident! Sorry my fault.

I've added the...

Ok, I am getting there, but I've run into a problem. Here is the trigger code I have created, but the problem is the TSQL part of the EVENTDATA...

Wonderful! That's what I was after.

Im just having a look at all the DDL events and will definitely be able to play around with these:

http://msdn.microsoft.com/en-us/library/bb522542.aspx

Thanks again.

Thanks guys, all very interesting stuff. I'm getting more in to how this application is implemented and it's becoming scary. As Sean Lange mentioned, the developers have implemented...

You can simple run the setup.exe of SQL server from the installation media and add integration services to the existing install.

Thanks guys. That article was scary reading. Very familiar and even some of the table names mentioned are the same as the ones the devs have deployed.

I really...

That's brilliant. Just what I needed for these initial tests. I was just starting...

Excellent. Thanks for the reply. It's good to know I was thinking along the same lines then.

Thanks.