Geeks With Blogs
urig Tidbits from a .net life May 2006 Entries
MS SQL locks sa account out automatically on having wrong password entered.
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 ......

Posted On Monday, May 29, 2006 3:36 PM

SQL Prompt - Free (!) IntelliSense for Microsoft SQL Server Management Studio
...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 ......

Posted On Tuesday, May 23, 2006 9:43 AM

YubNub - A command line interface for to the web.
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 ......

Posted On Monday, May 22, 2006 7:47 AM

.Net 2.0 SqlParameter rounds DateTime values (?)
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 ......

Posted On Sunday, May 21, 2006 3:52 PM

CTP stands for...

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.

Posted On Wednesday, May 17, 2006 1:27 PM

Error in VS2005 Documentation: FinishNavigationTemplate CommandName for "Finish" button
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 ......

Posted On Tuesday, May 16, 2006 2:18 PM

Bork Bork Bork! The Muppets' Swedish Chef on your FireFox
The Swedish Chef

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

Posted On Sunday, May 14, 2006 7:57 AM

Copyright © urig | Powered by: GeeksWithBlogs.net