Script to construct a restore/recovery script
Constructs a restore script for all databases on the server from backup history.
2012-11-12 (first published: 2012-09-26)
1,229 reads
Scripts
Search for String in all columns
Find all columns containing a string value across all tables and schemas.
2012-11-07 (first published: 2012-10-12)
2,049 reads
Shrinking all log files on SQL Server 2008R2
It shrinks all log files for the databases created by users.
2012-11-02 (first published: 2012-09-27)
3,916 reads
2012-10-30 (first published: 2012-10-12)
2,319 reads
Lists tables, Stored Procedures and other Objects
This stored procedure helps you list all tables, stored procedures, functions, view and triggers in a database.
2012-10-29 (first published: 2012-10-03)
1,877 reads
2012-10-26 (first published: 2012-10-02)
933 reads
2012-10-25 (first published: 2012-10-12)
1,940 reads
2012-10-23 (first published: 2012-09-12)
2,958 reads
New feature in SQL Server 2012 - Sequence
A new feature in SQL Server 2012 is Sequence. A Sequence object provides functionality similar to Identity.
2012-10-22 (first published: 2012-09-11)
2,045 reads
Show Job Run Snapshot
Show all job history between two dates. This is much easier than trying to navigate the job history log file viewer.
2012-10-19 (first published: 2012-09-17)
1,122 reads
Blogs
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Forums
How Do I Choose a Good Ophthalmologist in Dubai for Eye Checkups?
Choosing the right Ophthalmologist in Dubai starts with checking credentials, experience with children, and...
SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers