davidisnotnull · August 20, 2020 06:51
diff --git a/drop-all-users.sql b/drop-all-users.sql
 --Drop all Users in database 

 DECLARE @sql NVARCHAR(max)
 SET @sql = ''

 SELECT @sql = @sql+
 '
 print ''Dropping '+name+'''
 drop user ['+name+']
 '
 FROM
   dbo.sysusers
 WHERE
   name NOT IN('dbo','guest','INFORMATION_SCHEMA','sys','public')
   AND LEFT(name,3) <> 'db_'
 ORDER BY
   name

 print @sql

 execute ( @sql )
	--Drop all Users in database

	DECLARE @sql NVARCHAR(max)
	SET @sql = ''

	SELECT @sql = @sql+
	'
	print ''Dropping '+name+'''
	drop user ['+name+']
	'
	FROM
	dbo.sysusers
	WHERE
	name NOT IN('dbo','guest','INFORMATION_SCHEMA','sys','public')
	AND LEFT(name,3) <> 'db_'
	ORDER BY
	name

	print @sql

	execute ( @sql )