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.
2004-03-26
333 reads
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 […]
2004-03-19
160 reads
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
In June this year I took redundancy from the company I’d worked at for...
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
I am trying to use the STUFF command, however, the column using the STUFF...
Hello, We had a few errors with replication for SQL Managed Instance stopped working...
I am trying to setup a linked server and per the documentation it needs...
Ask SSC