July 6, 2008 at 6:11 pm
Hi,
How would you get the standard error string / description from an error number via the command line ? Is there any utility like the Informix - "finderr " ?
Regards
Gagan
July 6, 2008 at 6:33 pm
you could query sysmessages - that's where the error messages are stored.
---------------------------------------
elsasoft.org
July 6, 2008 at 7:09 pm
Yes, I have already tried that, but was looking for a OS level tool to retreive the error description. Let me know if you haev any idea on that...thank you.
July 6, 2008 at 7:16 pm
Heh. I always just Google it.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 7, 2008 at 8:39 am
to do it from the OS:
sqlcmd -Q "select * from sysmessages where ..." -dmaster -E -SYOURSERVER
🙂
---------------------------------------
elsasoft.org
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply