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!

Search results for query: *

  • Users: awebb
  • Order by date
  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...

Part and Inventory Search

Back
Top