Show Detailed Error in SQL Profiler

Posted by AlwaysBeCoding on Stack Overflow See other posts from Stack Overflow or by AlwaysBeCoding
Published on 2010-04-20T22:34:48Z Indexed on 2010/04/20 22:43 UTC
Read the original article Hit count: 153

Filed under:

Is there any way showing the detailed exception for String or binary data would be truncated. I use LINQ to SQL and i cant figure out which column is that!? Tried numerous things but i get the same meaningless error i got from within Visual Studio. Also I use .NET 3.5 SP1, but errors are still returned useless.

Related posts about sqlprofiler

Is a SqlProfiler Scan Started bad?

as seen on Stack Overflow - Search for 'Stack Overflow'
If in SqlProfiler you can see that to execute a query a Scan is Started, does this mean a full table scan or can it just be a lookup? If it can be both, how can you tell which one of the two it is? >>> More
Is this a bug in Profiler or Entity Framework?

as seen on Server Fault - Search for 'Server Fault'
Using Entity Framework 4 with stored procedures and SQL Server 2008 SP1... When running SQL Server Profiler (TSQL_SPs template), the lines that show my stored procedure call and its statements say that they executed in DatabaseID = 1 (Master) but it is actually happening in my application database… >>> More
TempDB is Full Issue for SQL Server 2000

as seen on Server Fault - Search for 'Server Fault'
Even though the log file shows that there is over 1 GB of free space, we start receiving an error message every 3 or 4 days saying that the TempDB file is full. I know cursors impact the TempDB file, but is there anything else I should be looking at to see why this keeps happening? I've tried running… >>> More
Unit of Measurement for Duration Column in Sql Profiler

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the Unit of Duration column in SQL Profiler? i thought it is milliseconds but in following profiler row i found it contradicting with start and end time spid=163 duration=11310646 starttime=2010-04-06 17:45:24.480 endtime=2010-04-06 17:45:35.790 reads=152 writes=2 cpu=16 eventclass=12 textdata=… >>> More
SQL Profiler: Read/Write units

as seen on Stack Overflow - Search for 'Stack Overflow'
i've picked a query out of SQL Server Profiler that says it took 1,497 reads: EventClass: SQL:BatchCompleted TextData: SELECT Transactions.... CPU: 406 Reads: 1497 Writes: 0 Duration: 406 So i've taken this query into Query Analyzer, so i may try to reduce… >>> More

Developer IT

Show Detailed Error in SQL Profiler - Developer IT

Show Detailed Error in SQL Profiler

c#3.0

sqlprofiler

linq-to-sql

Related posts about c#3.0

Linq Tutorial

Related posts about sqlprofiler

Is a SqlProfiler Scan Started bad?

Is this a bug in Profiler or Entity Framework?

TempDB is Full Issue for SQL Server 2000

Unit of Measurement for Duration Column in Sql Profiler

SQL Profiler: Read/Write units

Categories cloud