How to create a new login in SQL Server?

To create a new login in SQL Server you have to execute the following command:

CREATE LOGIN <LoginName> WITH PASSWORD='<Password>’

for more details check with MSDN link http://msdn.microsoft.com/en-us/library/ms189751.aspx

 

Advertisements