Creation of LOGIN user in SQL Server

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 300
The below code snippet is useful to create Login in SQL Server through T-SAL script


/* CREATE LOGIN LoginName WITH PASSWORD=’<Password>’ */
CREATE LOGIN [TestLoginName]
WITH PASSWORD=N'XXX', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=ON, CHECK_POLICY=ON
GO

Comments or Responses

Login to post response