2012-04-30 (first published: 2012-04-04)
675 reads
Scripts
Log Shipping - How you can convert the secondary database into primar
This topic explains the log shipping if the primary database is suspected or corrupted and how you can convert the secondary database into primary database.
2012-04-27 (first published: 2012-03-31)
1,015 reads
2012-04-26 (first published: 2012-04-02)
1,031 reads
2012-04-25 (first published: 2012-04-02)
2,257 reads
2012-04-24 (first published: 2012-03-30)
1,852 reads
Operators With Jobs and Notifications
This script will list the operators that have jobs
that are configured to notify them with alerts.
2012-04-23 (first published: 2012-03-29)
1,004 reads
Find Database Recovery Mode
The scripts provided below will show you the "Recovery Mode (Model)" for any given database
2012-04-19 (first published: 2008-03-18)
2,004 reads
Find for SQL Objects, Entities or Text
Procedure to find any object such as table/stored procedure by its name, or find for ant text inside stored procedures, functions.
2012-04-18 (first published: 2008-05-28)
2,990 reads
2012-04-17 (first published: 2008-02-15)
7,465 reads
Check owners, collations and backups
A script to check the owners, collations and backups on the server.
2012-04-16 (first published: 2007-10-19)
2,636 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers