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

487 reads

Blogs

Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2

By

(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...

Extended Events Misperceptions: Profiler is Easier, Part 2

By

I wrote a short blog post about the misperception that Profiler was easier than...

CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))

By

If you read the title to this post and your first thought was That’s...

Read the latest Blogs

Forums

ACV PLUS KETO

By khgaqwuopmnb

https healthygossips com/acv-plus-keto/  

DBCC showcontig help

By vicky

Hello Team, I am using DMV dm_db_index_physical_status to replace the DBCC is sql server...

Difference between connection, session and instance

By michael.leach2015

I am having trouble finding some clear definitions of these things.  Are the following...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers