Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Justice Gundam
Starting Member
5 Posts |
 Posted - 2010-02-22 : 04:28:27
|
Good morning.After resolving my issues concerning SQL triggers in Management Studio Express, I have another question that's troubling me. Whenever I use the PRINT and RAISERROR messages in writing my triggers, I can't manage to see the messages I have specified. Could anyone please tell me what I am doing wrong and how can I visualize those messages on-screen?Thank you very much!  |
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
Posted - 2010-02-22 : 04:52:46
|
| Which trigger you are using means at what database action you are using the trigger.are you activating trigger thourgh procedure or what? specify.Vabhav T |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-02-22 : 05:08:44
|
| you shouldn't try and present any messages with a trigger. You want a trigger to be as fast and efficient as possible. They need to be very slim otherwise you can cause yourself some horrible bottleneck problems.What are you trying to do?Feel free to post the trigger code also.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
Posted - 2010-02-22 : 05:14:21
|
| What might be the need for giving error message in trigger. please explainVabhav T |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-02-22 : 05:22:39
|
quote:
Originally posted by vaibhavktiwari83
are you activating trigger thourgh procedure or what? specify.Vabhav T
What do you mean by that???PBUH |
|
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
Posted - 2010-02-22 : 05:35:47
|
quote:
Originally posted by Idera
quote:
Originally posted by vaibhavktiwari83
are you activating trigger thourgh procedure or what? specify.Vabhav T
What do you mean by that???PBUH
I mean instead of giving msgs in trigger you can give it in procedure itselfVabhav T |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-02-22 : 07:32:47
|
quote:
Originally posted by vaibhavktiwari83
quote:
Originally posted by Idera
quote:
Originally posted by vaibhavktiwari83
are you activating trigger thourgh procedure or what? specify.Vabhav T
What do you mean by that???PBUH
I mean instead of giving msgs in trigger you can give it in procedure itselfVabhav T
But the earlier post was completely misleadingIt sounds "Are are calling a trigger using a procedure?"MadhivananFailing to plan is Planning to fail |
|
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
Posted - 2010-02-22 : 07:40:36
|
| That was ntAre are calling a trigger using a procedurethat was are you activating trigger thourgh procedure and let me clear myself you are using query for database action in procedure or directly...??Vabhav T |
|
|
|
|
|
|
PRINT and RAISERROR messages