When adding records to a table in the Enterprise Manager, I normally get the error messages from the Raiserror command in the trigger. When the Raiserror follows an "IF @@ROWCOUNT = 0" the message is "Data has changed since the Results pane was last updtated..." When running the same data from the Query Analyzer the messages all show up fine - regardless of the @@ROWCOUNT. Why doesn't EM always display the error messages like QA?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Error messages do not show in Enterprise Manager
- Thread starter awebb
- Start date
Similar threads
- Locked
- Question
- Locked
- Question