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,983 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,701 reads
2009-12-30 (first published: 2009-12-15)
1,081 reads
2009-12-23 (first published: 2009-11-26)
655 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)
531 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,300 reads
2009-12-18 (first published: 2009-11-26)
633 reads
2009-12-17 (first published: 2008-07-13)
1,875 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,225 reads
2009-12-14 (first published: 2007-10-19)
1,373 reads
Blogs
It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
Car Update October 2026
By Steve Jones
This month I want to look at a few of the things I’ve seen...
SQL Server 2016 Has Reached End of Support. Now What?
By SQLPals
SQL Server 2016 Has Reached End of Support. Now What? On...
Forums
PostgreSQL 19 Is Late
Comments posted to this topic are about the item PostgreSQL 19 Is Late
Hyperscale Replicas V
Comments posted to this topic are about the item Hyperscale Replicas V
A Heavy Heart
Comments posted to this topic are about the item A Heavy Heart
Question of the Day
Hyperscale Replicas V
I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?
See possible answers