• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 411
  • Last Modified:

How get error message on failed query observed from Profiler

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
vd
Asked:
vd
  • 2
1 Solution
 
caseyrharrisCommented:
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
 
vdAuthor Commented:
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
 
caseyrharrisCommented:
Good deal.  This question was selected to be deleted, can it stay up with the answer?

Thanks,
Casey
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now