Site Sections
Posts
119
Comments
115
Trackbacks
22
May 2007 Entries
SQL Profiler bug

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 @ Thursday, May 31, 2007 11:31 AM | Feedback (0)
AJAX: Unknown server tag 'asp:ScriptManager'.

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>
posted @ Wednesday, May 16, 2007 11:54 AM | Feedback (46)
Andrew Cohen is fired...

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

 

posted @ Tuesday, May 15, 2007 4:17 AM | Feedback (0)
serial for dinner and a cookie for dessert
Can anybody explain serializability to me?  Can any class be made serializable, but it's just better not to for some?
posted @ Tuesday, May 15, 2007 4:11 AM | Feedback (0)
I don't know what's more laughable...

...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/

 

posted @ Monday, May 14, 2007 10:31 AM | Feedback (0)
GETUTCDATE()
I often forget about GETUTCDATE() in T-SQL.  Not sure why.  It's very useful.
posted @ Wednesday, May 02, 2007 12:15 PM | Feedback (0)
Archives
Post Categories
News