CREATE TABLE #mytable ( UserName sysname, GroupName sysname, LoginName sysname Null, DefDBName sysname Null, UserID smallint, SID smallint ) INSERT #mytable EXEC sp_helpuser SELECT * FROM #mytable