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!

Register Log in
  • 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!

Recent content by awebb

  1. awebb

    Query Analyzer works Enterprise Manager Doesn't

    Even better. Got so wrapped up in the differences between QA and EM, I guess I lost site of the obvious. Thanks again.
  2. awebb

    Query Analyzer works Enterprise Manager Doesn't

    THANK YOU!! The key was 'return result sets'. I didn't understand that the default behavior (if that's the right term) of SELECT is to return a result set. The trigger needed a count of rows, but didn't need to return the result set. I changed to select into a temp table and everything works...
  3. awebb

    Query Analyzer works Enterprise Manager Doesn't

    Thanks for your response. I played around with SET NOCOUNT - unfortunately, to no avail. The trigger does 'fail' (at least in EM) immediately after the first 'Select' - even with SET NOCOUNT ON as the line before the Select. EM has the problem even when only change is a field which is not...
  4. awebb

    Query Analyzer works Enterprise Manager Doesn't

    I don't understand why a trigger works fine when fired from a statement in the Query Analyzer, but when fired by making a change to the table directly in the EM I get ODBC errors, first 'SqlDumpExceptionHandler: Process x generated fatal exception'. Then 'Communication Link Failure'. Since the...
  5. awebb

    Error messages do not show in Enterprise Manager

    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...
See more

Part and Inventory Search

Back
Top