Searching Column Name in All Tables
Use this script to search for a specific column name in all tables in a current database.
2010-01-01 (first published: 2009-12-09)
1,980 reads
Scripts
Automated SQL Job to Backup Database(s)
Automate All Database Backups with this script. handle full, diff, and log backups.
2009-12-31 (first published: 2009-12-15)
2,697 reads
2009-12-30 (first published: 2009-12-15)
1,074 reads
2009-12-23 (first published: 2009-11-26)
644 reads
Reset count for all alerts
To see the frequency of alerts in use, you can reset their fire count.
Restart count from zero for all alerts using the propre stored procedures.
2009-12-22 (first published: 2003-01-14)
521 reads
Synchronize several stored procedure between two servers
Synchronize source code between two servers for multiple stored procedures
2009-12-21 (first published: 2009-11-26)
2,292 reads
2009-12-18 (first published: 2009-11-26)
626 reads
2009-12-17 (first published: 2008-07-13)
1,871 reads
Synchronize all stored procedures between two servers
This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.
2009-12-15 (first published: 2009-11-26)
2,220 reads
2009-12-14 (first published: 2007-10-19)
1,370 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Telp BCA KCP Pasar Cibinong Cs 0823-74977784
Wa:082374977784 Ruko Mayor Oking Blok B. 1, Jl. Mayor Oking No. 35, RT 002/001,...
Telp BCA KCP Bojong Indah Cs 0823-74977784
Wa:082374977784 Komp. Bojong Indah Cengkareng, Jl. Pakis Raya No.88 H, RT.9/RW.6, Rw. Buaya, Kecamatan...
Alamat BCA KCP Metro Pasar Baru Telp:0821°8200°203
Telp/Wa 628218200203 Gedung Metro, Jl. Samanhudi No.103 Lt. Dasar No. 101, 102, Ps. Baru,...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers