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.
SAP Knowledge Base Article - Preview