• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 381
  • Last Modified:

sysdatabases & user access

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
anushahanna
Asked:
anushahanna
2 Solutions
 
cyberkiwiCommented:
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
 
Jim P.Commented:
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
 
anushahannaAuthor Commented:
very excellent. Thanks.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now