Solved

sysdatabases & user access

Posted on 2010-08-20
3
355 Views
Last Modified: 2012-06-27
is 'mode' have the value for the mode of the database?

http://msdn.microsoft.com/en-us/library/aa260406%28SQL.80%29.aspx
does not tell what it is?

or is there another place to check for SINGLE/MULTI user mode info for SQL 2000?

thanks
0
Comment
Question by:anushahanna
3 Comments
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 275 total points
ID: 33490239
Bitmask 4096 of the status column in the same link

select case when status & 4096 = 4096 then 'Single User' else 'Multi User' end, *
from master..sysdatabases
0
 
LVL 38

Assisted Solution

by:Jim P.
Jim P. earned 225 total points
ID: 33490315
You can use the sp_dboption 'single user' into a variable and then evaluate from there.

http://msdn.microsoft.com/en-us/library/ms187310.aspx
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33502322
very excellent. Thanks.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
search for a string in all tables 4 15
Mssql SQL query 14 28
Slow SQL query 12 29
SQL JOIN + SUBQUERY? 3 14
In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now