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?


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


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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