Repair Orphan Users All DBS
This procedure will resync all user/login sids, in all databases (unless limited). Excelent for use when restoring test environments.
2005-11-21 (first published: 2005-11-08)
1,752 reads
Maintenance and Management
Report Primary Keys
Quick and hassle free method of viewing the existing or non-existant primary keys in your database.
2005-11-16 (first published: 2005-10-28)
239 reads
All tablename and Record Count in a Database
Hello,Here is a way that help in getting all the table name and rowcount with in a database The use can give the database name and it will show the output for that database.Output can be ordered by name or by number of rows.To use it : Copy the script and run paste in QA […]
2005-11-14 (first published: 2005-10-24)
129 reads
Script Login Roles Permissions in all DBSs
Populate @list variable with account(s) to script. Save output to recreate:Login, Password,Default DB,Server Roles,DB Access,DB Roles,DB Object PermissionsDB level permissions are scripted in all databases. Can recreate a single login, or accepts comma delimted list of logins.NOTE:Stored procedures are created in Master, but are deleted
2006-01-19 (first published: 2005-10-19)
1,757 reads
Get scheduled jobs
The script is not as complete (and complex) as the USP_GetJobSchedules from M.Pearson, M. Austin and R.Sotkiewicz, but it gives a list of the scheduled jobs with start time, name, frequency, category and whether is enabled or not
2005-10-20 (first published: 2005-10-05)
442 reads
Notification of schema changes - Advanced
This script modifies another excellent script written by SHAS3. The original script examines tables for changes and sends an email. This modification examines all stored procedures, tables, indexes, etc. in ALL databases or just the CURRENT database. If changes are detected, the script has the option to either email or log to a table that […]
2005-10-26 (first published: 2005-09-28)
258 reads
Transaction Log Will Not Truncate
I saw a posting recently of a DBA not being able to truncate a transaction log. I rememberred this script that I had, (downloaded from Microsoft Support many moons ago), which did the job for me. It basically filled the log with data, then truncated and shrank the log. All important points throughout the script […]
2005-10-28 (first published: 2005-09-26)
402 reads
Shrink Log file for all Databases
I use this script to shrink the log files for development databases. The intention is keep the log files as small as possible when the database is not in use. By scheduling this script I can control when it happens as oppose to using auto shrink.
2005-07-08 (first published: 2005-06-29)
2,528 reads
Simple Recovery \ Truncate and Shrink
This script sets the recovery model for all databases to simple. It also truncates the log files before shrinking the databases.
2006-12-19 (first published: 2005-06-03)
326 reads
Run SQL on All servers in your inventory
There are many times you have to deploy a common code in all of your SQL Servers. I am sure there might be thousands of way to do this, but here is how I do it and it works great. Good thing is - you can either pass SQL Statement or a SQL script (in […]
2007-03-05 (first published: 2005-05-26)
825 reads
Blogs
Streamlining Azure VM Moves Into Availability Zones
By John
One of the more frustrating aspects about creating an Azure virtual machine is that...
Monday Monitor Tips: Native Replication Monitoring
By Steve Jones
Redgate Monitor has been able to monitor replication for a long term, but it...
Advice I Like: Art
By Steve Jones
Superheroes and saints never make art. Only imperfect beings can make art because art...
Forums
How to Merge PST Files efficiently with the PST Merge Tool
You can merge PST files efficiently by using a professional PST merge tool instead...
Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL
Comments posted to this topic are about the item Think LSNs Are Unique? Think...
Question of the Day
A Big PK
In SQL Server 2025, how many columns can be included in a Primary Key constraint?
See possible answers