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
458 reads
Scripts
Set All databases to DBO only and Single User Mode
Every want an easy way to set all database to DBO only and single user mode? Well here is a script to do that for you. This script is useful when you want to keep users out of the all the databases.
2002-09-23
1,328 reads
Turn off DBO and Single User mode for all DB's
Here is a companion script to "Set All databases to DBO only and Single User Mode" that will turn off dbo and single user mode for all databases.
2002-09-23
519 reads
Script To shrinking log file
for both 7.0 and 2000. It generates log table and triggers for main table.Its avaliable for all dbs on current server.
2002-09-21
686 reads
Script Database Objects
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,209 reads
Script to gain capacity information
Recently at my site we had a need to gather current capcatiy of all databases as well as table obejcts on our servers. although there are some out of the box stored proceudres to assist in this effort as well as some schema objects, they mostly would return information on one database at a time. […]
2002-09-20
287 reads
DTS package to read status of all jobs
This DTS package reads a list of servers from an XML configuration file, connects to each server, and writes a list of all failed jobs to a web page on the web server. Each morning, I just need to open my browser and I can see the status of all 42 of our servers.
2002-09-19
695 reads
Script All Jobs
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
907 reads
Sp to enable, disable or list all Triggers in DB
This one is For SQL 2000.This SP enable,disable or list all the Triggers in the given database.If enable or disable are specified, finds all the triggers of all the tablesand enable or disable them, After that, it list all the triggers with it´s current state.If List is specified, then it only list the triggers with […]
2002-09-19
700 reads
SP to get Trigger and Table info
It is a very simple but useful SP to get Trigger and related table info especially on databases having large number of tables.
2002-09-19
344 reads
Blogs
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
Forums
The SQL Server 2016 Plan
Comments posted to this topic are about the item The SQL Server 2016 Plan
whats that ssis analyzer product that documents lineage
hi, a few years ago was at a very large company that bought a...
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers