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.
I just spent an unhealthy amount of time trying to figure out this error:
Unknown server tag 'asp:ScriptManager'.
I was baffled because I already had a reference to AjaxControlToolkit.dll in my project, and I had what I thought was a web.config ready to handle any AJAX requests. It turned out adding the section below to system.web fixed the problem.
<pages>
<controls>
<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
</controls>
</pages>
Must I post a link to every article on a major news outlet's site that has spelling errors before they start using a spellchecker or a proofreader or something? Yesterday it was CNN, today it's CBS. I could understand if it wasn't in the title, in huge letters at the top of the article... unless "prosectuors" is a word now and nobody told me.
http://www.cbsnews.com/blogs/2007/05/15/couricandco/entry2803904.shtml
Can anybody explain serializability to me? Can any class be made serializable, but it's just better not to for some?
...the spelling mistake in the title, or the title itself. It really is amazing how often I find spelling/grammar mistakes on CNN's website.
As far as Bush actually pushing for greenhouse gas reduction, I guess we'll see...
http://money.cnn.com/2007/05/14/news/economy/bush_gas/
I often forget about GETUTCDATE() in T-SQL. Not sure why. It's very useful.