show-user-errors.JPG

<div>
Thanks for the quick reply &nbsp;! &nbsp; I had figured it out late last night but this is an excellent answer. Hopefully someone else will &nbsp;benefit from this. &nbsp; &nbsp; 
</div>


<div>
Good deal. &nbsp;This question was selected to be deleted, can it stay up with the answer?<br />
<br />
Thanks,<br />
Casey
</div>


<div>
<div class="content wysiwyg-content">
When using the Profiler tool, &nbsp;I can see the statement that a user has issued but when they get an error, <br />
I can't see the error. I seem to remember seeing this when using Profiler under SQL Server 2000. <br />
&nbsp;Is there a setting somewhere I have forgotten or how do I see the error ? 
</div>
</div>


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 ? 

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.     

Good deal.  This question was selected to be deleted, can it stay up with the answer?

Thanks,
Casey

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&#39;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 ? 

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.