The easiest way on sql server 2000 is to change the collation on the column you want to do the search on:

ALTER TABLE dbo.Customers ALTER COLUMN CustID char(8) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL

Apparently the allignment bug I encountered in vs2005 can be resolved by changing a number of options in the Formating options:

This is by design. The "Indent Case Contents" option under Tools | Options | Text Editor | C# | Formatting | Indentation indents everything from the opening brace to the closing brace. Our preview window is somewhat misleading since it only shows you the effects of the current formatting option.

In order to set your settings to the way you'd like, you'll need to uncheck both
"Indent Open and Close brace" and
"Indent Case Contents."

You'll also need to have "Place open brace on new line for control blocks" checked under Tools | Options | Text Editor | C# | Formatting | New Lines.

Thanks Karen Liu for helping me solve this.

With the PDC 2005 starting in a couple of weeks and the release of dasBlog 1.8 last Thursday, I present the TamTam PDC group blog. All content is supplied by cross-posting from our regular sites.

In Visual Studio 2005 there appears to be an allignment bug in switch/case statements as you can clearly see in this picture:

[bug details in MSDN Product Feedback Center]

Daniel McPherson points to a number of templates for Windows Sharepoint Services, available on Micorsoft downloads, to help with common tasks in every organization.

Windows SharePoint Services Applications Template: Room And Equipment
Windows SharePoint Services Applications Template: Expense Report Portal
Windows SharePoint Services Applications Template: Event Planning
Windows SharePoint Services Applications Template: RFP Management
Windows SharePoint Services Applications Template: HR InfoPath Forms
Windows SharePoint Services Applications Template: Professional Services Contractual Setup
Windows SharePoint Services Applications Template: Loan Initiation Management
Windows SharePoint Services Applications Template: Change Management
Windows SharePoint Services Applications Template: Meeting Management
Windows SharePoint Services Applications Template: Classroom Management
Windows SharePoint Services Applications Template: Legal Document Review
Windows SharePoint Services Applications Template: Employee Scheduling
Windows SharePoint Services Applications Template: Marketing Communications Campaign Site
Windows SharePoint Services Applications Template: Employee Training
Windows SharePoint Services Applications Template: IT Developer
Windows SharePoint Services Applications Template: HelpDesk Dashboard
Windows SharePoint Services Applications Template: Board of Directors
Windows SharePoint Services Applications Template: Project Team Management
Windows SharePoint Services Applications Template: Absence Request and Vacation Schedule Management
Windows SharePoint Services Applications Template: Competitive Intelligence

Available on SourceForge.net, haven’t found anything yet, excellent work Omar, Scott and everybody else.

[full list of new features]

public static string HashPasswordForStoringInConfigFile(
   string password,
   string passwordFormat
);

In the FormsAuthentication class in the System.Web.Security namespace.

The first parameter is the string you want hashed, the second is the hashalgorithm, “sha1” or “md5”, to use.

[more info on msdn]