Cacher is the code snippet organizer for pro developers

USE [master];
GO
CREATE LOGIN username 
    WITH PASSWORD    = N'password',
    CHECK_POLICY     = OFF,
    CHECK_EXPIRATION = OFF;
GO
EXEC sp_addsrvrolemember 
    @loginame = N'username', 
    @rolename = N'sysadmin';