Technical Article

Server User Access

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

493 reads

Blogs

Goal Progress for Jan 2023

By

The grade for January is a D. Details below, but just not making a...

Context Info Across Databases–#SQLNewBlogger

By

Does Context Info work across databases? This post shows it does. Another post for...

Introducing… Data On Rails!

By

Data On Rails is a Data On Wheels project designed to give a platform...

Read the latest Blogs

Forums

Identity column and "EntityID" column naming convention

By CreateIndexNonclustered

This is specific to 2022, but SQL in general. I will be joining a...

Replace Primary Server keeping same Log Shipping Server

By BobAtDBS

I have a two node SQL Standard 2014 Failover Cluster at the primary site. ...

Memory Issue With A SQL Server Express 2019 Server Database Application

By Rob Reid-246754

Hi, I have just moved a DB from an old HP laptop, to a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers