No problem. Thanks for the help! I'm making the vendor deal with it.

Duh. I should have thought of that! Another question though. This is supposed to dump data I can use to create a report. Where is that...

Here it is:

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AAA_CP_CustomDataExport]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[AAA_CP_CustomDataExport]

GO

--exec AAA_CP_CustomDataExport NULL, '01/01/06', '01/31/06'

CREATE PROCEDURE...

I really appreciate all the advice! I think I have a grasp on it now. The good thing is this is very small operation...3 employees, not a...

You guys are fast!

Here's my dilemma. Every hour when the tlog is backed up, my only choices are to overwrite or append. If I append, and...