Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

up vote 1 down vote accepted

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

USE Master
Go
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 http://msdn.microsoft.com/en-us/library/ms176112%28SQL.90%29.aspx

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

 
discard

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.