Thanks for all your help.

Susan 

Thanks for your help, I tried the code above added with my insert statement, but not sure I'm declaring my table variable in the right spot. Here is the error...

We don't want to process more than 100,000 rows at a time because the job runs long. We need a commit every 1000 so the table is released between deletes.

I...

You can pass parameters to stored procs that are in a job. We do it all the time.

exec Delete_Task_Result 120

You could also create one stored proc that executes...

Two words for you Amit..

YOU ROCK!!!

thanks soo much for your help.

The result's I used were from amitjethva.

Thanks in advance

Thanks.. that is EXACTLY what I'm looking. Now my only issue is putting the info into a table. Every time I try an insert I get an error message that...

Sorry forgot to add the script

/*******************************************************************************

  Written By  : Simon Sabin

  Date        : 25 October 2002

  Description : Returns the spaceused by all tables in a database

              :

  History

 ...

I found this article in

Microsoft Knowledge Base Article - 816939

PRB: File Growth Value for TempDB is Not Persistent When Changed From Fixed Increments to Percentage

I'm...

I thought the 'auto_statistics' 'On' option would have already updated the stats and the plan. I thought when the stats are updated automatically, the SP's would in turn be marked...

Right, they are revisiting the query and plan on revising it. However, I just don't understand how recompiling the SP's would fix the slow down issue. My understanding that the...

The proc really runs a dbcc flushprocindb

Here's the code..

create procedure sp_flush_db_procs

@dbname sysname=NULL

--

-- Flush the Procedure cache for a database.

--

-- If no database name is supplied then flush

-- the current database.

--

-- WARNING: This SP uses...