Many thanks Richard - fits the bill exactly
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Richard Kaye Sent: 06 July 2018 18:08 To: profox@leafe.com 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 profoxtech-bounces@leafe.com On Behalf Of Paul Newton Sent: Friday, July 06, 2018 8:45 AM To: profoxtech@leafe.com 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]