IF SUSER_ID('gaps') IS NULL BEGIN CREATE LOGIN gaps WITH PASSWORD = 0x02007868AC6E83FCA949CA70084EB581D31B0A3250B24BCD718FBF84ECC05497F363E5E71998D54DA43654FB138F1FBF70CDE6A4EB606E19DB0A17DC41AA0136E2F77DD01598 HASHED END CREATE USER [gaps] FOR LOGIN [gaps] WITH DEFAULT_SCHEMA = [dbo] /*ALTER ROLE db_ddladmin ADD MEMBER gaps*/ exec sp_addrolemember 'db_ddladmin', 'gaps' /*ALTER ROLE db_datareader ADD MEMBER gaps*/ exec sp_addrolemember 'db_datareader', 'gaps' GO