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

Actually, two questions, after looking closer at the procedure, are you sure it works?  Looks like the set and select for Result_Code are outside the procedure to me.

I have a question, why?

Create the indexes with the data in place.  It would take longer to reload the data to the tables if you created the indexes on empty tables, as it would...

I believe that SP2 was also released for Windows Server 2003 R2 Enterprise x64 Edition.  This is the version of the OS we are running for our Data Warehouse development...