Thanks to those who replied.

I am ambarrassed to say that the front end programmer gave me a bum steer, an I wasn't updating the table I thought I was!! DOH!!

I...

I have only managed to make this work on the server. When I try to run it from query analyzer on the client, I get the same problems -...

Andy,

I have put your idea to my mamager (the three table idea was not mine, just a directive from above).

He has come back with:

If the tables live in...

I have read with interest the postings here. I am called the back-end developer. I enjoy T-SQL, and have sort of drifted further & further to the back...

I would love to use S2K, but the software I am working on is for an external client, and they will not upgrade their OS to support it!! (I think...

Please don't aplologise, the information has been invaluable. Before now, I had not used triggers, but had controlled everything via stored procedures, so I didn't need them. I...

OK, I have now changed my code to get rid of one cursor, by bringing my sp code into the trigger. One problem is that now I can't...

Hi Nigel,

Thanks for your post. My trigger has changed significantly since my last post. I am not very clued up on triggers, I don't like them, and have...

Yes, thank you both, I was trying to write a fairly generic trigger (hence the dynamic SQL), which I could apply to any table I wanted to audit. ...

The server is runnign SQL Server 7

As some of you will already know, mu code is fatally flawed. The sp_executesql cannot see my deleted statement. I tried to do a select * into #deleted...

Thanks

Ok,here it is..

Within an update trigger I want to call a stored proc to write one, maybe two audit records. The first audit table has just one field in...

Thanks!!