Solved

question about my mssql environment requested by vendor

Posted on 2014-11-25
2
43 Views
Last Modified: 2014-12-01
schema name for the "john.doe" user account
this is a sql user and not a domain user account


how to i retrieve this information?

sql server 2008
0
Comment
Question by:jamesmetcalf74
2 Comments
 
LVL 9

Accepted Solution

by:
teebon earned 500 total points
ID: 40466007
Hi James,

You can run this query to check

SELECT * FROM sys.database_principals where (type='S' or type = 'U')

Open in new window

0
 

Author Comment

by:jamesmetcalf74
ID: 40466774
Hi
that did retrieve some of the users but less than half and not the one i needed...
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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.

775 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