sys.server_principals & sys.syslogins

what is the reason for 2 system views to hold the same login info?

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
sys.server_principals - Starting from SQL Server 2005, its recommended to use this view.
sys.syslogins  - This is a compatibility view to support 2000 databases and hence not recommended for use starting from SQL Server 2005.
0
 
anushahannaAuthor Commented:
OK. Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.