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 […]

You rated this post out of 5. Change rating

2002-02-11

516 reads

Blogs

A New Word: Gnossienne

By

gnossienne– n. the awareness that someone you’ve known for years still has a private...

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

By

How I used AI for this postChatGPT to generate images based on info specifically...

Learning Tool – Deepstash

By

A few months ago I started using Deepstash. Deepstash breaks books into the key...

Read the latest Blogs

Forums

How Can SQL Server Detect Application Errors When Developers Can’t?

By Pablo Echeverria

Comments posted to this topic are about the item How Can SQL Server Detect...

Getting Database MaiL Profiles

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting Database MaiL Profiles

Preserving Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Preserving Data

Visit the forum

Question of the Day

Getting Database MaiL Profiles

If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?

See possible answers