trigger help needed
-
mj,
noone is trying to be rude.
But thist problem is really created by you.
You are stuck with single solution you know and you are trying to use it where it's not appropriate.
If you are not sure the table exists you may check it with Object_ID('TableName').
Before you state that solution is not in books you better read the books.
_____________
Code for TallyGenerator -
Think "language barrier" and email mono-tones folks... Sometimes folks get pretty short and it isn't meant to be rude... it just sounds that way. Add English as a second language and sometimes things that aren't meant to be come off as being really rude and isn't meant to be.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Yep... I know that xp_CmdShell is "serial" and not asynchronus in nature... that's why I normally check the data before I put it in a trigger. But, I have seen it work well as a kind of "unconditional audit" and I've not had the pleasure (
) of deadlock on it, yet, although I see where it could. Guess I've been lucky... 
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply