Blog Pages

SAP ASE (Sybase) - write to the server log - logprint

dbcc logprint('itai test errorlog')
-- will be written with severity=0
or:

sp_addmessage 20002, 'itai test sp_addmessage with_log'
raiserror 20002
-- will be written with severity=0

or:

sp_addmessage 20002, 'itai test sp_addmessage with_log', @with_log=TRUE
raiserror 20002
-- will be written with severity=16

or with parameters:
sp_addmessage 20003, 'itai %1! sp_addmessage with parameters', @with_log=TRUE
raiserror 20003, 'parameter'
-- will be written with severity=16

No comments:

Post a Comment