This script runs from the master database and records all the databases on the server. It then checks each database for users and records their name and the database(s) on which they have access. You can then create a nice cross tab report using any report designer (I used crystal) showing users on the databases […]
2002-02-11
501 reads
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
By Steve Jones
The more I work with the Data API Builder (DAB), the more I lean...
By Steve Jones
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...
We are self hosting sql servers, we are not using Azure for sql servers....
Hi everyone, Trying to get this data to the following format but I can't...
I am trying to implement a SSRS reporting dashboard similar to the SQL-performance-dashboard-reports that...
When does a column declared as SPARSE use no storage?
See possible answers