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

x
?
Solved

question about my mssql environment requested by vendor

Posted on 2014-11-25
2
Medium Priority
?
54 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 2000 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

Independent Software Vendors: 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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

877 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