• Nice article thanks.

    One thing I found interesting in 05 is that when you use the UI to script an existing login, it still uses the old syntax!

    /****** Object: Login [aamin] Script Date: 04/11/2008 09:58:34 ******/

    EXEC master.dbo.sp_addlogin @loginame = N'mylogin', @passwd = @randomPwd, @defdb = N'master', @deflanguage = N'us_english'