SQL 2000: Track Stored Procedure Changes
SQL Server 2000 does not log the procedures modified using ALTER statement. Here's the script to find out the same.
2009-04-07 (first published: 2009-03-02)
1,246 reads
Satish More
Code Comparison between two databases
This script compares the code (SP, Func. etc.) between two databases (say Dev and QA) and reports the objects which have differences.
2007-03-30 (first published: 2007-03-08)
613 reads
Blogs
Microsoft Ignite Announcements 2021
By James-Serra
Microsoft Ignite has always announced many new products and new product features, and this year...
Daily Coping 4 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Which configuration changes in SQL Server require a restart?
SQL Server is a complex beast, with many configuration options that can range from...
Forums
Backing up SQL Express with batch file and SQL procedure.
I have a procedure to back up a SQL Express database. It works when...
Missing cmdlet in powershell module sqlserver
I have succesfully installed the module sqlserver version 21.1.18235 on my server which hosts...
Datacenter Downtime and SQL backups
I was wondering what others are doing in regards to a datacenter outage and...
Ask SSC