Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. SELECT
  2. RIGHT(name, 10) name,
  3. CASE
  4. WHEN is_disabled = 1 THEN 'No'
  5. WHEN is_disabled = 0 THEN 'Si'
  6. END [¿Habilitado?],
  7. RIGHT(default_database_name,15) BD
  8. FROM **sys.sql_logins**
  9. WHERE name = 'SA'
  10. AND is_disabled = 0
  11.  
  12. SELECT RIGHT(name, 10) name,
  13. RIGHT(dbname,15) BD
  14. FROM master.dbo.syslogins
  15. WHERE sysadmin = 1 --name = 'SA';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement