Home Forums SQL Server 2008 SQL Server 2008 - General Minimum rights required to add users to a DB RE: Minimum rights required to add users to a DB

  • July 10, 2013 at 9:17 am

    #1631267

    lloks like the string is constructed slightly wrong: thank goodness for the print statements!

    CREATE LOGIN [test1] WITH PASSWORD = 'password',N' DEFAULT_DATABASE=[Master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;

    i think the cod eneeds to be changed like this:

    SELECT @cmd = 'CREATE LOGIN ' + QUOTENAME(@name)

    + ' WITH PASSWORD = N'''

    + @password

    + ''',DEFAULT_DATABASE=[Master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;'

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!