Technical Article

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

174 reads

Technical Article

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

138 reads

Blogs

Daily Coping 20 May 2020

By

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

Daily Coping 19 May 2022

By

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

Running dynamic SQL in a different database

By

This is one of those things that on hindsight was a stupid problem, but...

Read the latest Blogs

Forums

Running Trace - Error: Login timeout expired

By ramana3327

Hi All, We have Project server 2019 (Sharepoint). The database server (Only Database services...

query perf issue

By siri_28

Hi Everyone, Good morning. I am new to Sql administration.Have one question. We work...

Looking for some guidance on avoiding Scalar UDFs for DB lookups

By SteveOC

Hello. I am not a SQL Developer - just an IT generalist (if that)...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers