How to use CREATE LOGIN sql statement?

Posted by truthseeker on Stack Overflow See other posts from Stack Overflow or by truthseeker
Published on 2010-10-04T11:13:24Z Indexed on 2010/12/26 8:54 UTC
Read the original article Hit count: 294

Filed under:
|
|
|

Hi,

How to use CREATE LOGIN statement on SQL Server 2005?

I was trying nearly everything, with commas, without them, with strings, without them etc.

CREATE LOGIN @loginame WITH PASSWORD = 'pass', DEFAULT_DATABASE='dbname' DEFAULT_LANGUAGE='us_english', CHECK_POLICY= OFF;

I always get below error:

Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server