Stacey Gregerson


Linked SQL Servers,  databases, and users Report

Fixed user protion of the script. Sorry had the test script mixed with prod. I was asked to create a report listing all of our SQL Servers, and the databases on them. I was also asked to list everyone that has access to each database and whether it was a standard, windows or windows group […]

2002-10-15

1,043 reads

Blogs

Daily Coping 15 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Another One Bites the Dust - PASS is Gone, so...What Now?

By

There has been a lot of noise over the last few weeks since it...

SQL Server Linux

By

If you have come from a windows background you may be curious about the...

Read the latest Blogs

Forums

Grouping AND OR Logic

By Stavros_McGillicuddy

I am trying to use this logic ((1 OR 2) OR 6 OR 7...

alternative to temp tables with 3M+ records and growing

By ricky969

I'm struggling with the performance of one of my stored procedures. Depending on the...

One AD group login not visible to user

By webrunner

Hello experts, I have an odd issue. A user asked me to provision SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers