Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

sys.server_principals & sys.syslogins

Posted on 2010-09-09
2
Medium Priority
?
1,582 Views
Last Modified: 2012-05-10
what is the reason for 2 system views to hold the same login info?

thanks
0
Comment
Question by:anushahanna
2 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 2000 total points
ID: 33636721
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
 
LVL 6

Author Comment

by:anushahanna
ID: 33636727
OK. Thanks.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question