It appears that there my have been a truncate of the log file done between the differential backup (file 3) and the next transaction log backup (file 4).

I am guessing...

If the scripts above are accurate, I don't see you using the NORECOVERY option while restoring the differential backup.

Also, what happens if you restore the full backup (file 1) and...

I have gone back through my posts and have found four threads for this same procedure.

I really can't stress enough that you need to try to solve your problems first...

As a consultant would say: It depends.  If some columns are accessed or updated more frequently than others, it may make sense to vertically partition the table.  It really comes...

Never had a reason to do what you are trying to do.  When I started a job with sp_start_job, that was all I was interested indoing as I was doing...

I know I am getting old, but this looks like your asking the same question again.  After you start the job using sp_start_job, you will need to loop inside your...

Only way I know, is to hard code the tablename inside the trigger.

I would recommend putting up the $50.00 for SQL Server 2005 Developer Edition.  It is well worth the investment!

Not sure about others, but I could use the DDL for your tables and some sample data and expected results so that i could do some testing.

Also, a default value is only inserted if you don't provide a value for that column.  In your insert statement, a value is being provided, which defeats the purpose of...

That was one of the options I was looking at, but I think I found what I wanted, and it was staring me in the face the whole time: the...

Any help here would be appreciated.

Thanks

The reason you were getting a zero inserted is that '' converts to 0 when cast as an int.  Try this:

select cast('' as int) -- the return value is 0

No.  Do the proc the way I had it.  the execute statement looks something like this then (read BOL to be sure of the syntax).

declare @myvalue int

exec dbo.Load_Audi_Excel @myvalue =...

Humor me, try this and see if it does what you want:

CREATE PROCEDURE [dbo].[Load_Audit_Excel]

     (@Return_Code int Output)

AS

BEGIN

SET NOCOUNT ON;

    SELECT @Return_Code = count(*) FROM [Header$]

    EXEC msdb.dbo.sp_start_job @job_name='Audit'

END

thanks