May 2006 Entries
Strange behavior from MS SQL Server 2005. I "spontaneously" get this error when trying to connect: Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it. (Microsoft SQL Server, Error: 18486). After some digging I've found this useful chain of posts, logged into the server locally and ran the following line: ALTER LOGIN sa WITH PASSWORD = 'your_password_here' UNLOCK I suspect what happened was that MS SQL Server decided to lock the sa login...
...and for the old Enterprise Manager and Query Analyzer and for Visual Studio 2003 and 2005 and for UltraEdit and EditPlus (!) SQL Prompt is a freeware from Red Gate Software. It's a stand-alone app that sniffs the text you type into your IDE and beautifies and auto-completes it as you go. I've tried it and I recommened it. It's a memory hog though. It's taking up over 30MB of RAM on my machine even though it only has to store 4 DB schemas right now. Thanks go to Shahar for the referral. His blog...
I've just learned about the coolest web app - YubNub. I read about it in Roy Osherove's blog. What it does is, it gives you a "command-line interface" to the web by allowing you to type in simple commands and then transfering you to corresponsing URLs. For example, to browse an entry in WikiPedia, I usually type-in to my FireFox: http://en.wikipedia.org/wiki/X where X is the entry I'm looking for. In YubNub all I have to do is type-in wiki X and whammo! I'm there. YubNub has tons more of useful commands...
Just ran into a bit of nastiness with the SqlParameter class in .Net 2.0. The scenario: I have a DateTime with a value of '05/30/2006 23:59:59.999' (that's 999 milliseconds). When I save it to a (Microsoft SQL Server 2005) DB using a stored procedure invoked by SqlHelper.ExecuteNonQuery(), the value surprisingly changes to '05/31/2006 00:00:00.000'. A bit of step-by-step debugging led me to the culprit. When the DateTime is stored in a SqlParameter to be passed to SqlHelper.ExecuteNonQuery(), the...
Hallelujah! I've finally managed to uncover what Microsoft so cryptically refers to as "CTP". CTP is an acronym that stands for Community Technical Preview in Microsoft's current marketing lingo. Pretty much a synonym for a beta release, only targeted at professional clients and not the general public
I've been messing around with an ASP.Net 2.0 Wizard Server Control, trying to customize a FinishNavigationTemplate. I followed the instructions in the the Microsoft Visual Studio 2005 Documentation page for FinishNavigationTemplate (ms-help link here) which said: The FinishNavigationTemplate object that is contained in the FinishNavigationTemplate property must contain two IButtonControl controls, one with its CommandName property set to "MoveFinish" and the other with its CommandName property set...
Bork Bork Bork! (now at version 1.4) lets you view web pages or mail as spoken by the Swedish Chef. Or as the Chef himself would say: "Feeoo veb peges oor meeel es spukee by zee Svedeesh Cheff."