table sys.sql_logins in SQL Server 2000 validation of the following query in SQL Server 2000;
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
You have to use system view dbo.syslogins of database master . However, not all columns in sys.sql_logins view are available in this oldest view (for example, is_disabled no longer exists, so you should check which column you should use for this filter) and others columns have different names:
SELECT RIGHT(name, 10) name,
RIGHT(dbname,15) BD
FROM master.dbo.syslogins
WHERE sysadmin = 1 --name = 'SA';
sys.sql_logins = syslogins, hasaccess = 1 (access to the server has been granted.)
Final query:
SELECT
RIGHT(name, 30) name,
CASE
WHEN hasaccess = 1 THEN 'SI'
WHEN hasaccess = 0 THEN 'NO'
END AS [¿Habilitado?],
RIGHT(dbname,15) BD
FROM
syslogins
WHERE sysadmin = 1