June 6, 2014 at 10:49 am
Hi,
every time I try to execute some commands I get this message from SQL Server:
Msg 50000, Level 11, State 1, Procedure TRG_CHANGE_BI_SINGULARES, Line 45
Já existe um Contribuinte com o mesmo BI ( 2403100099 - ANTÓNIO MÁRIO )
Msg 3609, Level 16, State 1, Line 1
The transaction ended in the trigger. The batch has been aborted.
This is a trigger or a stored procedure?
How can I drop the trigger?
June 6, 2014 at 11:05 am
The procedure is triggering the trigger. You need to figure out which table it's on. Insert/Update/Delete will cause it.
However, you don't want to randomly drop a trigger, you want to find out what it's doing, why it's there, etc. Hopefully you can talk to the system architect.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply