Using sp_altermessage : sp_altermessage « System « SQL Server / T-SQL

1.	Aggregate Functions
2.	Analytical Functions
3.	Constraints
4.	Cursor
5.	Data Set
6.	Data Type
7.	Database
8.	Date Timezone
9.	Index
10.	Insert Delete Update
11.	Math Functions
12.	Select Query
13.	Sequence
14.	Store Procedure Function
15.	String Functions
16.	Subquery
17.	System
18.	Table
19.	Table Joins
20.	Transact SQL
21.	Transaction
22.	Trigger
23.	View
24.	XML

SQL Server / T-SQL » System » sp_altermessage

Using sp_altermessage



 





The sp_altermessage system stored procedure is used to alter the state of an error message.



Syntax for the sp_altermessage System Stored Procedure



sp_altermessage [ @message_id = ] message_number ,

  [ @parameter = ] 'write_to_log' ,

  [ @parameter_value = ] 'value'



--Using sp_altermessage



sp_altermessage

  60000,

  'WITH_LOG',

  'true'

GO

Related examples in the same category

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.