If you wish to save the contents of your database as insert statements, this script will generate a text file that has all data formatted as insert statements. This way you can save off the data as a script to send to a client or combine with a create script to rebuild the database on […]
2005-07-29 (first published: 2005-07-18)
861 reads
I use this script to quickly compare databases. In the past, I would generate creation scripts and compare those but that is tedious at best. This script generates a report of the metadata in an easy to read format that includes...- Table and Field Listing with types.- Foreign Key information- Primary Key and Index information- […]
2005-07-28 (first published: 2005-07-18)
579 reads
By Steve Jones
One of our mission statements in the Book of Redgate says: attempt to do...
On May 8, 2025, we hosted our first official event in Switzerland at Prime...
By Steve Jones
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...
Hi, I would love to hear if anyone can tell me why a CAST...
hi, one of our sister division's erp extract view is going thru at least...
hi our corp dw load sqlagent job goes to the next step on the...
In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?
See possible answers