How to retrieve roles from a Database

If you have environment where you restrict access to database objects based on user roles and if you have a lot of databases on different servers in the same domain.  The following script can generate roles from a given database in a format that can be used to create roles on different servers where the […]

2003-05-14

172 reads

How to get Foreign keys

If you ever have been put in a situation where your database has a lot of objects and some of those do not have primary keys, trying to find feels like needle in the haystack.  I have modified the script contributed by Mr.Tandrei and Mr.Rahul sharma.  The following script gives all the tables that do […]

2003-04-17

137 reads

Blogs

Daily Coping 24 Sept 2021

By

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

Using environment variable files for SQL Server in containers

By

There are a whole bunch of environment variables that can be used to configure...

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Read the latest Blogs

Forums

Volunteer For Something

By Grant Fritchey

Comments posted to this topic are about the item Volunteer For Something

Linked Server location?

By pkarandi

I have inherited a SQL Server that makes a call to a Linked Server...

Merge issue

By DaveBriCam

I have a merge stored procedure that may be conflicting with the structure of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers