If you want to create a new login on SQL Server, what is the proper syntax?
- CREATE LOGIN login_id WITH PASSWORD = password
- CREATE LOGIN login_id WITH USE = password
- CREATE LOGIN login_id USE = password
- USE LOGIN login_id WITH PASSWORD = password
EXPLANATION
Somebody on the Microsoft team decided that this syntax – create a login with this password – made sense. Even if it's arbitrary, you can't say it isn't intuitive.https://msdn.microsoft.com/en-us/library/ms189751.aspx
0 comments:
Post a Comment