Monday, March 12, 2012

How to add message to sql server log?

Hi!
I use MSSQL 2000. I want add message to sql server log, i use raiserror with
log and it works, but it add unnecessary message about error, severity and
state. How can i add only my message? Thanks!
Best regards, Konstantin Knyazevtry using xp_logevent
"Konstantin Knyazev" <kknyazev_no_spam_@.mail.ru> wrote in message
news:eJUjx6FRGHA.224@.TK2MSFTNGP10.phx.gbl...
> Hi!
> I use MSSQL 2000. I want add message to sql server log, i use raiserror
> with
> log and it works, but it add unnecessary message about error, severity and
> state. How can i add only my message? Thanks!
> Best regards, Konstantin Knyazev
>|||xp_logevent also adds second message about error.
"Immy" <therealasianbabe@.hotmail.com> wrote in message
news:%23JzAU%23FRGHA.5296@.tk2msftngp13.phx.gbl...
> try using xp_logevent
>
> "Konstantin Knyazev" <kknyazev_no_spam_@.mail.ru> wrote in message
> news:eJUjx6FRGHA.224@.TK2MSFTNGP10.phx.gbl...
and
>

No comments:

Post a Comment