Use commands to create a user
Below is a simple example of adding a login account:
Exec sp_addlogin 'pattern'
RememberProgramUse the exec keyword before the name.
The following is a complicated example of adding a new login account.
Sp_addlogin 'sharonr', 'mypassword', 'northwind ', 'us _ English'
This command creates a user named sharonr and uses the mypassword password. The default database is northwind and the default language is U. S. English. In general, it is better to enable SQL Server to establish security identification than you do.
The sp_grantlogin pre-stored program has the following syntax:
Sp_grantlogin 'login _ name'
An example of using the sp_grantlogin prestorage program is as follows:
Exec sp_grantlogin 'mountain _ dew \ dickb'
After adding these login accounts, select the logon data folder in the left pane to view these login accounts in enterprise manger.