----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: _SQL_Vinod_ Message 3 in Discussion Please Note that the following table lists all the instances (i think all :)) when the @@error fails to catch. These are mostly system level error and the code block will just abort. Error<o:p></o:p> Aborts<o:p></o:p> Duplicate primary key.<o:p></o:p> Statement<o:p></o:p> NOT NULL violation..<o:p></o:p> Statement<o:p></o:p> Violation of CHECK or FOREIGN KEY constraint<o:p></o:p> Statement<o:p></o:p> Most conversion errors, for instance conversion of non-numeric string to a numeric value.<o:p></o:p> BATCH<o:p></o:p> Attempt to execute non-existing stored procedure<o:p></o:p> Statement<o:p></o:p> Missing or superfluous parameter to stored procedure to a procedure with parameters.<o:p></o:p> Statement<o:p></o:p> Superfluous parameter to a parameterless stored procedure.<o:p></o:p> BATCH<o:p></o:p> Exceeding the maximum nesting-level of stored procedures, triggers and functions.<o:p></o:p> BATCH<o:p></o:p> Being selected as a deadlock victim.<o:p></o:p> BATCH<o:p></o:p> Permission denied to table or stored procedure.<o:p></o:p> Statement<o:p></o:p> ROLLBACK or COMMIT without any active transaction.<o:p></o:p> Statement<o:p></o:p> Mismatch in number of columns in INSERT-EXEC.<o:p></o:p> <o:p> </o:p> BATCH<o:p></o:p> <o:p> </o:p> Declaration of an existing cursor<o:p></o:p> Statement<o:p></o:p> Column mismatch between cursor declaration and FETCH statement.<o:p></o:p> Statement<o:p></o:p> Running out of space for data file or transaction log<o:p></o:p> BATCH<o:p></o:p> HTH, Vinod Kumar www.ExtremeExperts.com ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
