Hi virgo,

You can change the code over to the following that uses suser_sname(sid) instead of [name]. I'll update the posted script accordingly. Thanks for finding that issue.

+ ' FOR LOGIN ' + QUOTENAME([name]) +

+ ' FOR LOGIN ' + QUOTENAME(suser_sname([sid])) +

SELECT'IF NOT EXISTS (SELECT [name] FROM sys.database_principals WHERE [name] = ' + SPACE(1) + '''' + [name] + '''' + ') BEGIN CREATE USER ' + SPACE(1) + QUOTENAME([name]) + ' FOR LOGIN ' + QUOTENAME(suser_sname([sid])) + ' WITH DEFAULT_SCHEMA = ' + QUOTENAME([default_schema_name]) + SPACE(1) + 'END; ' AS [-- SQL STATEMENTS --],

4 AS [-- RESULT ORDER HOLDER --]

FROMsys.database_principals AS rm

WHERE [type] IN ('U', 'S', 'G') -- windows users, sql users, windows groups

I tested it out and seems to work for what you need.

Regards,

Steve