Technical Article

Script object or user permissions

script useful for copying permissions from one database to another like test to production.Tim Stahlhut SEE sp_helprotect for params meaning Note: If you wish to script system object permission remove 'IsMSShipped' block of code. Fixed missing code & re-formatted it to look better.

You rated this post out of 5. Change rating

2004-03-26

332 reads

Technical Article

SP to enable, disable or list all Triggers in  DB

SQL 7.0 and 2000 modified version of Rodrigo Acosta (racosta) Argentina Script that enable,disable or list all the Triggers in the given database. If enable or disable are specified, finds all the triggers of all the tables and enable or disable them, After that, it list all the triggers with it´s current state. If List […]

You rated this post out of 5. Change rating

2004-03-19

159 reads

Blogs

Create and Verify Microsoft Fabric Capacity

By

From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....

What is Always Encrypted and how does it work?

By

Always Encrypted was a new encryption feature added to SQL Server with the 2016...

Power BI – Empowering Users to Disable Tooltips

By

Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...

Read the latest Blogs

Forums

M & C CONSTRUCTION SERVICES @0810757135 IN JOHANNESBURG,TEMBISA,SOWETO,ALEXANDRA

By M C CONSTRUCTION SERVICES

M & C Construction Services +27810757135 has been providing construction services to a long...

Efficient Airport Transfer in Mauritius - Reach Your Destination with Ease!

By limofahr

Make your arrival in Mauritius hassle-free with our efficient airport transfer service. Our experienced...

how to determine if we can delete the index can be removed

By 892717952

In SQL Server database, there is a table InventDim with two indexes: Idx1 with...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Refresh Limits

See possible answers