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
337 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
162 reads
By Steve Jones
amoransia – n. the melodramatic thrill of unrequited love; the longing to pine for...
By Steve Jones
One of the things that I like about the Data API Builder (DAB) is...
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Comments posted to this topic are about the item Technical Pain Behaviors
Hello, trying to call a powershell file I created, locally on the server, but...
Comments posted to this topic are about the item Counting Bits
What does the BIT_COUNT function do in SQL Server?
See possible answers