Bug in MSKB918992 ("How to transfer the logins...") - How to report?

Hi all,

I found a bug in the listing in Knowledge Base Article 918992 ("How to
transfer the logins and the passwords between instances of SQL Server
2005"). Instead of

SET @tmpstr = 'CREATE LOGIN ' + QUOTENAME( @name ) + ' WITH PASSWORD = ' +
@PWD_string + ' HASHED, SID = ' + @SID_string + ' DEFAULT_DATABASE = [' +
@defaultdb + ']'

it should be

SET @tmpstr = 'CREATE LOGIN ' + QUOTENAME( @name ) + ' WITH PASSWORD = ' +
@PWD_string + ' HASHED, SID = ' + @SID_string + ', DEFAULT_DATABASE = [' +
@defaultdb + ']'

A colon has to be added before DEFAULT_DATABASE. Now while this little bit
of information might be useful to somebody here, the primary reason for this
posting is that the stupid interface for reporting bugs on the MS web site
(http://connect.microsoft.com/feedback/default.aspx?SiteID=68) drove me
nuts! It wouldn't let me sign in for reporting bugs, I could only search. Is
this offering restricted to a selection of VIP users or something? Can
anybody enlighten me here? I was just trying to be helpful...

Thanks and best regards
Nils Loeber


.

Relevant Pages