SELECT
		'DROP LOGIN ['+name+']'		
FROM
		sys.syslogins
WHERE
		name LIKE 'acs%'
		AND name NOT IN ('')
ORDER BY
		name

SELECT
		p.name AS [loginname] ,
		p.type ,
		p.type_desc ,
		p.is_disabled,
		CONVERT(VARCHAR(10),p.create_date ,101) AS [created],
		CONVERT(VARCHAR(10),p.modify_date , 101) AS [update]
FROM
		sys.server_principals p
        JOIN sys.syslogins s
			ON (p.sid = s.sid)
WHERE
		p.type_desc IN ('SQL_LOGIN', 'WINDOWS_LOGIN', 'WINDOWS_GROUP')
        -- Logins that are not process logins
        AND p.name NOT LIKE '##%'
        -- Logins that are sysadmins
        AND s.sysadmin = 1
ORDER BY
		loginname

SELECT
		COLUMN_NAME+'=LTRIM(RTRIM('+COLUMN_NAME+')),',
		COLUMN_NAME+'=CASE WHEN LEN('+COLUMN_NAME+') = 0 THEN NULL ELSE '+COLUMN_NAME+' END,'
FROM
		INFORMATION_SCHEMA.COLUMNS
WHERE
		TABLE_NAME LIKE 'NOME_TABELA'
ORDER BY
		ORDINAL_POSITION

DECLARE @Texto VARCHAR(MAX)

SET @Texto=''

SELECT
		name
FROM
		sys.procedures
WHERE
		OBJECT_DEFINITION(object_id) LIKE '%' + @Texto + '%'

EXEC sp_change_users_login ''Auto_Fix'', ''NOME_USUARIO'', NULL, ''permitido''