Results 1 to 2 of 2

Thread: Problem with rollback trigger

  1. 08-06-2003, 05:11 AM #1
    level8
    level8 is offline Registered User
    Join Date
    Aug 2003
    Location
    Hungary
    Posts
    3

    Problem with rollback trigger

    Hi, Everybody,

    I'm a Hungarian SQL user and I need a little help for SQL Server 7!

    I protect my table against bad data with a trigger. I use ROLLBACK and RAISERROR statement in this trigger. Users can get my error message after manual input, but the stored procedure always cancel because of ROLLBACK. So the input program dont't have chance to analyze the error message. I could work without ROLLBACK, but it wouldn't be the best solution.

    What's the correct solution with ROLLBACK statement?
    Reply With Quote Reply With Quote
  2. 08-06-2003, 09:46 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    http://forums.databasejournal.com/sh...threadid=32729
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules