2009-12-17 (first published: 2008-07-13)
1,855 reads
2009-12-17 (first published: 2008-07-13)
1,855 reads
This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.
2009-12-15 (first published: 2009-11-26)
2,197 reads
2009-12-14 (first published: 2007-10-19)
1,356 reads
Use this stored procedure to synchronize source code of a stored procedure between two servers.
2009-12-11 (first published: 2009-11-26)
2,009 reads
2009-12-09 (first published: 2009-11-18)
2,078 reads
2009-12-07 (first published: 2009-11-12)
3,089 reads
Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.
2009-12-04 (first published: 2009-11-10)
2,030 reads
2009-12-02 (first published: 2009-11-11)
874 reads
Returns the First or last day date of the month for a given date.
2009-12-01 (first published: 2009-11-11)
2,862 reads
Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method.
2009-11-27 (first published: 2009-10-30)
980 reads
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Security on your SQL Server is important. That doesn’t need any explaining. But where...
It’s that time of year again! EightKB is back on August 20th at 13:00...
WA CS 08218154392 Jl. Jenderal M.t. Haryono No.95, Bende, Kec. Kadia, Kota Kendari, Sulawesi...
Comments posted to this topic are about the item Backing Up a DMK
Comments posted to this topic are about the item The Quiet Part
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers