Grant user role permission in SQL Server 2005 using script

Here is the script to create role in Sql Server 2005. you need to pass '$(username)' parameter in this script file.



CREATE LOGIN [$(username)] FROM WINDOWS;
GO

EXEC sp_addsrvrolemember [$(username)], 'securityadmin';
GO

EXEC sp_addsrvrolemember [$(username)], 'dbcreator';
GO


Happy Coding...