Solved

sysdatabases & user access

Posted on 2010-08-20
3
368 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
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…
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…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

636 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