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.