Post reply

create login

  • June 3, 2011 at 7:25 pm

    #241639

    When I execute the following T-SQL DDL statement:

    create login ravid with password = 'ravid' DEFAULT_DATABASE = plu

    I get this syntax error:

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near 'DEFAULT_DATABASE'.

    Please tell me what is the syntax error in the statement.

  • June 3, 2011 at 9:34 pm

    #1333992

    Try this.

    create login ravid with password = 'ravid', DEFAULT_DATABASE = plu

  • June 3, 2011 at 11:16 pm

    #1333998

    Thank you worked.

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

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