Many thanks Richard - fits the bill exactly -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Richard Kaye Sent: 06 July 2018 18:08 To: [email protected] Subject: RE: SQL Server Restrict Access property
select name, user_access_desc from sys.databases; Courtesy of my company DBA, who is a wizard. -- rk -----Original Message----- From: ProfoxTech <[email protected]> On Behalf Of Paul Newton Sent: Friday, July 06, 2018 8:45 AM To: [email protected] Subject: SQL Server Restrict Access property Hi all I want to be able to query the Restrict Access property (MULTI_USER, SINGLE_USER or RESTRICTED_USER) for a SQL Server database. Does anybody know of a way to do this? Many thanks Paul Newton [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/sn1pr0201mb1856fb9269788cadb706ae14a1...@sn1pr0201mb1856.namprd02.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
