Have created the superuser but get the following error now :angry:

CREATE LOGIN [test1] WITH PASSWORD = 'password',N' DEFAULT_DATABASE=[Master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;

Msg 105, Level 15, State 1, Line 1

Unclosed quotation mark after the character string ' DEFAULT_DATABASE=[Master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;'.

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near ' DEFAULT_DATABASE=[Master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;'.

CREATE USER [test1] FOR LOGIN [test1];

Msg 15007, Level 16, State 1, Line 1

'test1' is not a valid login or you do not have permission.

EXEC sp_addrolemember N'VFF_Permissions', N'test1';

Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 75

User or role 'test1' does not exist in this database.

The above refers to the below and I can correct the syntax error if I remove the 'N', but then still get the permissions error I was getting previously. It shouldn't be this difficult!

SELECT @cmd = 'CREATE LOGIN ' + QUOTENAME(@name)

+ ' WITH PASSWORD = ''' + @password +''','

+ 'N'' DEFAULT_DATABASE=[Master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;'