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