Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to see the view definition for the system views sys.syslogins and sys.sysusers. I am a domain admin and logged on to the server as such. Any ideas?

share|improve this question
up vote 1 down vote accepted

Use the following T-SQL to view the definition of syslogins.

USE Master
sp_helptext 'sys.syslogins'

Replace 'sys.syslogins' with 'sys.sysusers' to see the definition of sysusers.

This, of course, assumes that your domain Admin userID has the appropriate rights within SQL Server.

sp_helptext is an inbuilt stored procedure that can be used to view the definitions of views and stored procedures within SQL Server databases. For more information, see

share|improve this answer
Spent quite a while on Google trying to figure this out - thanks very much! – Marko Carter May 20 '10 at 13:10
You're welcome! – Thomas Rushton May 20 '10 at 13:32

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.