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