List All Users

--------------------------------CODE START----------------------------------
SET NOCOUNT ON
DECLARE @name varchar(50)
DECLARE logon_cursor CURSOR FOR
select name from sys.server_principals WHERE
name LIKE '%' AND name NOT LIKE 'NT AUTHORITY%'
OPEN logon_cursor
FETCH NEXT FROM logon_cursor
INTO @name
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @name
-- Get the next author.
FETCH NEXT FROM logon_cursor
INTO @name
END
CLOSE logon_cursor
DEALLOCATE logon_cursor
GO
-------------------------------CODE END-----------------------------------------