Explanation: sys.databases contains information about all databases on the SQL Server instance. • HAS_DBACCESS(name) = 1 filters out the databases you dont have access to. •ORDER BY name sorts the result alphabetically.
2025-03-04
172 reads
2021-05-26 (first published: 2021-04-30)
8,690 reads
In this tip we look a script to find SQL Server logins and database users that have read or write access to any database in the instance.
2019-09-20
Here is a short How To article on querying for permissions in a SQL Server database
2014-07-01
10,486 reads
On May 8, 2025, we hosted our first official event in Switzerland at Prime...
By Steve Jones
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...
By Kevin3NF
Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....
I have a record, in those the three columns where firstname / last name...
Comments posted to this topic are about the item Execution Plan Operators
--for a given member if the startdate and endate is continous we need to...
When looking at an execution plan in SSMS, what types of operators are shown?
See possible answers