Including text in alert

Last Post 13 Jul 2011 01:16 PM by PaulMcKibben. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
PaulMcKibben
New Member
New Member

--
11 Jul 2011 09:29 AM
I have defined an alert to send an email to me with the error 18456 occurs using SSMS.  Is there a way that can set the alert to include the user-id and the client IP that failed the login attempt?

Thank you.
rm
New Member
New Member

--
12 Jul 2011 06:11 AM
Sql should replace parameters with those info when fires alter.
PaulMcKibben
New Member
New Member

--
13 Jul 2011 10:49 AM
RM,

Thank you, but the following is what I am receiving:

DATE/TIME: 7/13/2011 12:46:01 PM

DESCRIPTION: (None)

COMMENT: (None)

JOB RUN: (None)

I would like to have the email include the user-id and possibly the client IP in it if possible.
russellb
New Member
New Member

--
13 Jul 2011 12:33 PM
Did you check the include error text in email option?
PaulMcKibben
New Member
New Member

--
13 Jul 2011 01:16 PM
No I hadn't. Thank you.


Acceptable Use Policy
---