Thanks for replying Steve. I'm not going to have direct access to the pipe which will essentially be an encrypted tunnel created by the two hardware devices. I'm taking a...

Thanks all. I am going to explore the compression options.

Can the other party convert to a standard backup file and then encrypt using a non-proprietary, non-red gate method?

Thanks for your respsonse.

>> like to know how often are you planning to move the data from onsite to offsite.

The system we are evaluating has two-modes, traditional run the job...

Red Gate SQL Data Compare will generate DELETE, UPDATE and INSERT statements to synch databases.

Copy from a template file where your template has all the formatting and macros you need.

Untested code

DECLARE @cmd VARCHAR(1000)

DECLARE @TemplateFile VARCHAR(200)

SET @TemplateFile = 'Template.xls '

DECLARE @DestinationFile VARCHAR(200)

SET @DestinationFile = 'MyFile.xls...

Are you getting an error? If so, what is it?

A potential workflow alternative may be to:

-delete the file

-copy from a template to make a new file

-write your data

BEGIN TRY functionality is awesome, but alas I am on 2000.

See http://www.db-staff.com/index.php/microsoft-sql-server/62-dba-tips-Query to archive a backup file using winrar without access to the server desktop

This looks good thanks.

DELETE #Test_Destination

FROM #Test_Destination a

inner join #Test_Staging b

on a.id=b.id and a.Date=b.Date

INSERT INTO #Test_Destination

SELECT a.*

FROM #Test_Staging a

left join #Test_Destination b

on a.id=b.id and a.Date=b.Date

where b.id is null

Yes, this is what I am looking for. Thanks.

That updates all manufacturers with the same MIN date in the #ProductInfo table

I need the MIN date per product.

The updated #Manufacturers table would look like:

ManufacturerID,Manufacturer_Date

1,1/1/2009

2,2/15/2009

3,1/15/2009

I think the OP wanted to distinguish between recurring and one-time unavailabilities.

I see your point though. There could really be a type field with the choices being 'recurring' and 'one-time'.

I...

You could have 3 fields: starttime,endtime,dayofweek.

If dayof week is populated then this would indicate a recurring unavailability. If not populated then it is the specific dates in starttime and endtime....

Check the views in the msdb database that start with dbo.sysmail*.