February 4, 2009 at 5:39 am
Hi,
Please Help.
I have implemented DDL trigger (For LOGON) on my MSSQL2005 instance which will restrict the users to access the SQL server with their respected Machin’s ips (restriction entries are stored in separate table).
It’s working fine but what I want is User should know why they are not able to login from other Machines.
For this I want to customize MSSQL Error Massage after trigger fires, and put user friendly text in error massage instead of mssql massage ‘Logon failed for login 'xyz' due to trigger execution. [CLIENT: ]’
For the same I tried ‘RAISERROR(50001,1,1) WITH LOG’ function but it only add the entry in event log and not showing the massage to user while login failures.
Is it possible to customize MSSQL Error Massages or replace MSSQL Error Massages with user massages?.If yes How?
Thanks In advance.
Regards,
Sameer D. Bhagat.
February 4, 2009 at 6:24 am
Hi,
I hope u can try trapping the error in try/catch block of your trigger and then display the required error either by storing in a log table or directly.
srihari nandamuri
Comments please....
Srihari Nandamuri
February 5, 2009 at 2:24 am
February 5, 2009 at 7:23 am
ta.bu.shi.da.yu (2/5/2009)
If someone finds a way getting a massage from SQL Server, can they let me know? I've been feeling a bit tense...
It's obviously no good, they want to replace with user massages.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 5, 2009 at 8:16 am
If they use oil, I'm all for replacing with user massages.
February 9, 2009 at 12:07 am
Hi,
have a look at this atrticle. I hope it would help you.
http://www.sqlservercentral.com/articles/Error+Description/65013/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply