Symptom
Would like a process to suppress messages from writing to a client; only send the message to the ASE errorlog.
For example:
- sp_addmessage 20500,"The login: '%1!' - The message and Ticket output: '%2!'", null, true, "replace"
go
- If you raise the error with:
declare @loginname varchar(30), @ticket varchar(40)
select @ticket='Test'
select @loginname=suser_name()
raiserror 20500,@loginname,@ticket
go
Actual Results:
To the client:
Msg 20500, Level 16, State 1:
Server 'servername', Line 4:
The login: 'sa' - The message and Ticket output: 'Test'
ASE errorlog:
Error: 20500, Severity: 16, State: 1
The login: 'sa' - The message and Ticket output: 'Test'
Desired results:
To the client:
Nothing written to the client
ASE errorlog:
Msg 20500, Severity: 16, State: 1
The login: 'sa' - The message and Ticket output: 'Test'
Read more...
Environment
SAP Adaptive Server Enterprise 16.0
Product
Keywords
going receiving receive message log enhancement request , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.