Geeks With Blogs


The Wrecking Bawl Destructuring query language, one keyword at a time.

I discovered the most fascinating and annoying bug in version 9.00.1399.06 (the RTM version) of SQL Profiler 2005 today.  When I would execute a stored procedure from ASP.Net, the date parameters shown in the Profiler window would always have two single quotes on both sides, e.g. ''2/2/2002 22:00:00'' (yes, those are single quotes, not double)

This of course returns an error if you copy the statement and try to run it in Query Analyzer.  I was baffled for hours.  How could this be happening?  And why does it seem like the stored procedures are executing fine?

I eventually realized that I wasn't using the latest version of Profiler, so I decided to download SP2 for SQL Server 2005.  I installed it and ran the procedures again, and voila!  Everything looks normal now, and I can sleep tonight.

Posted on Thursday, May 31, 2007 11:31 AM all tech stuff , SQL Server | Back to top

Comments on this post: SQL Profiler bug

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Alex Bransky | Powered by: