Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- RIGHT(name, 10) name,
- CASE
- WHEN is_disabled = 1 THEN 'No'
- WHEN is_disabled = 0 THEN 'Si'
- END [¿Habilitado?],
- RIGHT(default_database_name,15) BD
- FROM **sys.sql_logins**
- WHERE name = 'SA'
- AND is_disabled = 0
- SELECT RIGHT(name, 10) name,
- RIGHT(dbname,15) BD
- FROM master.dbo.syslogins
- WHERE sysadmin = 1 --name = 'SA';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement