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

You rated this post out of 5. Change rating

2003-05-14

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

You rated this post out of 5. Change rating

2003-04-17

139 reads

Blogs

ERD Your Existing Databases

By

There are several tools out there to make your life easier by creating an...

AI World

By

this month is the big month and a month to remember their are so...

Using Flyway with Feature Flags

By

There is a nice article at Harness.io on their use of feature flags and...

Read the latest Blogs

Forums

The Costs and Rewards of Speaking

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Costs and Rewards of...

Manage Elastic jobs in Azure using Azure Elastic Jobs Manager

By Kunal Rathi

Comments posted to this topic are about the item Manage Elastic jobs in Azure...

Takeaways from Data Grillen 2024

By Tonie Huizer

Comments posted to this topic are about the item Takeaways from Data Grillen 2024

Visit the forum

Question of the Day

Inserting Transaction Marks

When is a transaction mark first inserted into the msdb.dbo.logmarkhistory table?

See possible answers