Viewing 15 posts - 871 through 885 (of 1,195 total)
The Dixie Flatline (12/21/2012)
The Dixie Flatline (12/21/2012)
Stuart Davies (12/21/2012)
ImOuttaHere (Happy Christmas and New Year)Romulan
Actually, Stuart doesn't look at all Romulan.
Thanks - I'll take that as a compliment (I think)
December 23, 2012 at 2:33 am
As it is the last working day of the year for me (and I'm not on call :-D) I'll sign off for the year and wish all of you...
December 21, 2012 at 9:00 am
Gianluca Sartori (12/21/2012)
ChrisM@Work (12/21/2012)
Koen Verbeeck (12/21/2012)
ChrisM@Work (12/21/2012)
Anybody out there?Yes, but I'm very busy fighting off the zombie apocalypse.
I thought that big scary yellow thing in the sky was the zombie...
December 21, 2012 at 3:04 am
SQLRNNR (12/20/2012)
bcsims 90437 (12/20/2012)
crookj (12/20/2012)
Rob Schripsema (12/19/2012)
SQLRNNR (12/19/2012)
Ray K (12/19/2012)
L' Eomot Inversé (12/19/2012)
SQLRNNR (12/19/2012)
TalonHawk(e)
Hawkeye
Pierce
Hot Lips!
Radar
M*A*S*H!!!!!
(We're showing our age)
Honeycut
Klinger
December 21, 2012 at 2:37 am
Thanks for the question.
Can I ask that they are all like this until the New Year?
December 18, 2012 at 1:29 am
An update:-
All is now working and the code is running 100% OK.
I simplified the trigger as after research I found that I didn't need the join to ttask, the id...
December 17, 2012 at 6:59 am
The overnight system gremlins were a bit busy last night - so this is having to go on hold.
As and when I have anything futher, info, scripts etc - I'll...
December 13, 2012 at 3:01 am
Hi Ron,
full script is :-
CREATE TRIGGER [dbo].[TASSIGNMENT_DTRIG] ON [dbo].[TASSIGNMENT] FOR DELETE AS
SET NOCOUNT ON
INSERT INTO utils..TassignmentLogging
...
December 12, 2012 at 9:12 am
No rollbacks or fails for that matter - as far as I can see.
The trigger is the only one on the table and is as simple as script above
December 12, 2012 at 9:00 am
Hi Anthony,
No the deleted table is not the ttask table.
In trying to trouble shoot this myself I can get values for fields in the deleted table and put those into...
December 12, 2012 at 8:54 am
Lowell (12/12/2012)
Stuart what is the relevance of this WHERE statement coming from?WHERE ttask.id = 23
are you only capturing queries that match a certain task type?
Correct - at the moment we...
December 12, 2012 at 8:37 am
Viewing 15 posts - 871 through 885 (of 1,195 total)