Post reply

SP_help_revlogin and Default DB output

  • May 29, 2008 at 10:22 am

    #121631

    In Sql Server 2005 when I run sp_help_revlogin the output for sql login will miss the comma [,] after SID and before Default Database statement.

    I am wondering if this is a bug, as I don't see any reason why we need to update the output with comma's before Implementing script to other servers.

    -- SQL Login: abcbatch sp_help_revlogin output

    CREATE LOGIN [abcbatch] WITH PASSWORD = 0x0100C85E1233A8F44083013B3AF1016B7A343535138D4CF6B4D36 HASHED, SID = 0x76C302C1FF59D311A8BA01237B1838B DEFAULT_DATABASE = [EDM], CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF

    [Comma missing before default]

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • May 29, 2008 at 12:07 pm

    #821914

    It seems like it's working fine for me.

    http://support.microsoft.com/kb/918992

    -- Login: abcbatch

    CREATE LOGIN [abcbatch] WITH PASSWORD = 0x0100426FF48BA5C8A93F45E51C4AA866286B2B010A0F9735D846 HASHED, SID = 0x125002F102F0184ABDA7E8CA604588D3, DEFAULT_DATABASE = [EDM], CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF

    Ola Hallengren

    http://ola.hallengren.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply