We were experiencing significant issues with Cross Domain Log Shipping, even after getting help from Microsoft. The main reason was that in SQL Server 2000 you cannot access the Log Shipping Wizard from a scripting interface. This set of stored Procedures is all you need to setup a good log shipping framework in your organization […]
2005-08-01 (first published: 2005-07-18)
3,040 reads
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)
878 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)
595 reads
If you wish to Format Number to 2 decimal without rounding it then, here is the trick.This is also useful when you are dividing 2 numbers and you need answer in 2 digiits only without rounding
2005-07-25 (first published: 2005-06-23)
512 reads
It is quite often that we need to find Nth (5th or 8th or 10th) maximum or minimum number of record from the record set. The solution is different in MS SQL than in Oracle because we have RowNum in Oracle. Some time ago I got the same problem with a massive table of more […]
2005-07-22 (first published: 2005-07-05)
1,068 reads
Script lists 'First day of the week','Last day of the week','Last day of the month' and 'First day of the month'
2005-07-21 (first published: 2005-07-07)
679 reads
There was a problema user was reflecting http://groups.yahoo.com/group/sqlcon/message/1119What I did was following steps1. Divide the count of table into segments for divide2. Then use the even Odd functionality for smooth looping3. Use a simple while loop and SET ROWCOUNT functionality for further deletions across table with checkpoint4. It saved the log swell up and resources […]
2005-07-20 (first published: 2005-07-07)
282 reads
First Day of the Month, First Weekday, Total Days in this Month, Days In First WeeK, Days In Last Week,Total Weekend Days sample output: Given Date:Jul 16 2005 12:00AM First Day of the Month:7/1/2005 First Weekday (sun=1,sat=7):6 Total Days in this Month:31 Days In First Week:2 Days In Last Week:1 Total Weekend Days:10
2005-07-15 (first published: 2005-06-21)
226 reads
Split function accepts a string and a delimeter.It divides the string in words by the delimeter.
2005-07-14 (first published: 2005-06-22)
356 reads
Have you tried using DTS to load a database and those pesky foreign keys mess you up? This is actually two scripts, one to generate the SQL needed to drop all the Foreign Keys in a database and another to Add the Foreign Keys back when you are done. I've thrown in Disabling and Enabling […]
2005-07-13 (first published: 2005-06-22)
3,072 reads
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Hub Via Wa:62817825533 Alamat: Jl. Pantai Indah Kapuk Utara I Blok F, RT.6/RW.2, Kamal...
Hub Via Wa:62817825533 Alamat: ABC dan 11 H, Jl. Pangeran Tubagus Angke No.10, RT.14/RW.11,...
Hub Via Wa:62817825533 Alamat: Jl. Enggano No.22-23, RT.8/RW.16, Tj. Priok, Kec. Tj. Priok, Jkt...
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