Viewing 14 posts - 16 through 29 (of 29 total)
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...
January 30, 2002 at 5:13 am
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 -...
January 28, 2002 at 2:27 pm
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...
January 25, 2002 at 8:44 am
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...
January 25, 2002 at 4:34 am
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...
January 25, 2002 at 4:03 am
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...
January 24, 2002 at 1:05 pm
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...
January 24, 2002 at 4:55 am
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...
January 24, 2002 at 3:44 am
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. ...
January 23, 2002 at 12:28 am
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...
January 22, 2002 at 7:46 am
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...
January 20, 2002 at 11:04 am
Viewing 14 posts - 16 through 29 (of 29 total)