?
Solved

How get error message on failed query observed  from Profiler

Posted on 2008-06-16
3
Medium Priority
?
397 Views
Last Modified: 2011-10-19
When using the Profiler tool,  I can see the statement that a user has issued but when they get an error,
I can't see the error. I seem to remember seeing this when using Profiler under SQL Server 2000.
 Is there a setting somewhere I have forgotten or how do I see the error ?
0
Comment
Question by:vd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
caseyrharris earned 500 total points
ID: 21802946
In profiler when running a new trace select "show all errors" in the lower right and then expand errors section and check user errrors.  See attached screen print.  Let me know if this does the trick.
show-user-errors.JPG
0
 

Author Comment

by:vd
ID: 21803037
Thanks for the quick reply  !   I had figured it out late last night but this is an excellent answer. Hopefully someone else will  benefit from this.    
0
 
LVL 3

Expert Comment

by:caseyrharris
ID: 21803093
Good deal.  This question was selected to be deleted, can it stay up with the answer?

Thanks,
Casey
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question