Script tem o objetivo de encontrar login com a role SysAdmin e informar seu status.
2011-08-04 (first published: 2011-07-25)
2,749 reads
hgutsche,
2011-08-22
Script tem o objetivo de encontrar login com a role SysAdmin e informar seu status.
-- Data da criação: 22/08/2001 -- Criado: Wellington A. Vitoriano (DocTom\WellingtonSQL) -- wellington_sql@hotmail.com select name Login, case(status) when '9' then 'Habilitado' when '10' then 'Desabilitado' else STR (Status) end as 'Status', case (sysadmin) when '1' then 'Administrador' when '0' then 'Não Administrador' else STR (sysadmin) end as 'Permissão' from syslogins order by sysadmin desc
2011-08-04 (first published: 2011-07-25)
2,749 reads
2012-01-05 (first published: 2011-12-09)
2,320 reads
This script will display information about the instance(s) on your cluster. Name of nodes, active node and drive letters of the resources
2009-05-08 (first published: 2009-04-15)
1,337 reads