NuRoN Consulting, INC.

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

Blog > SQL Tools > Template Scripts > Users > Drop and non sysadmin users

Template Script: Users\Drop and non sysadmin users.sql

DECLARE @SQL VARCHAR(MAX)
SELECT  @SQL = Util.dbo.StringConcat('DROP LOGIN [' + name + ']', '
')
FROM    sys.syslogins
WHERE   sysadmin = 0
        AND isntuser = 1
        AND name NOT LIKE '%admin%'
        AND name NOT LIKE 'firstamdata%'
PRINT @SQL
IF @SQL < > ''
    EXEC(@SQL )

Description for Template Script: Users\Drop and non sysadmin users.sql

Todo