Script All Object Permissions
Quick and dirty script to generate the required SQL to reinstate permissions on each user object. This can be saved off for DR purposes.
2002-09-24
435 reads
Quick and dirty script to generate the required SQL to reinstate permissions on each user object. This can be saved off for DR purposes.
2002-09-24
435 reads
Others have asked for this throught the disussion threads so I thought others might benefit as well.This SQL-DMO script will create multiple files for server logins (SIDs & encrypted passwords), database users, tables, procedures and views.1. Alter the script to reflect your server and path for output files.2. Create the job (ActiveX Script).Be great!Michael
2002-09-20
1,191 reads
We utilize this to script our jobs on a scheduled basis. The main advantage is that it is automated and really comes in handy when there is a large number of jobs.1. Create a job; ActiveX Script.2. Paste the code; change the server/path to your desired values.
2002-09-19
887 reads
By Steve Jones
Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG...
By Steve Jones
Today’s coping tip is to go to bed in good time and allow yourself...
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
Hi all! AWS has a good example of how to manipulate the requested objects...
Is the SQL Script plug-in listed here no longer available? SQL Scripts in SSMS...
Hi folks, I have a single Postgres instance on RDS that in the past...