NuRoN Consulting, INC.

File Download
Donate for FREE Code
SQL Tools
- Databases
- Template Scripts

Blog > SQL Tools > Template Scripts > Login > sp_change_users_login

Template Script: Login\sp_change_users_login.sql

-- FIX SQL LOGINS WITH NO USER
SELECT  'EXEC sp_change_users_login ''Auto_Fix'', ''' + name + ''', NULL, ''' + name + ''';'
FROM    sys.database_principals
WHERE   type = 's'
        AND name NOT IN ('dbo', 'guest', 'INFORMATION_SCHEMA', 'sys', 'cdc')

Description for Template Script: Login\sp_change_users_login.sql

Todo