SQL Server 2005 Standard Logins and Local Security Policies
Just a heads-up: if you create a standard login for SQL Server 2005 databases running on computers where local and global password policies apply, you might be in for a surprise...
More details in my SQLJunkies blog over here.