Since the OP didn't give us much info, we're left to speculate wildly to cover all possible scenarios.

Ratheesh.K.Nair (5/5/2009)

---

U mean the issue is due to SQL server?

Shrink the db having high log file size.

Check the temp DB, if its huge and ur server is not production then...

DTSRun /S ServerName /E /N"PackageName"

see: http://msdn.microsoft.com/en-us/library/aa224467(SQL.80).aspx

george sibbald (5/1/2009)

---

remove the need to monitor the log space used from the procedure by setting up a performance alert in SQLAgent to backup the log when it reaches a...

Here are the main table schemas (sorry for all the bandwidth - I tried to de-clutter it). The stored procedure is written to use a cursor for the table deletes...

That's what I was wondering. Wasn't there a bug in the original version that was fixed by a leter Service pack ?

Good point. I'm not aware of any changes, but I'll look into it.

Does your package connect to a network file ? Maybe you don't have permission to a folder.

I could do that. But I wanted to leave the code as original as possible.

No blocking. There was a table scan on a 56,000 record table, but they run this every week without incident. I added indexes to fix that but no help. We...

Would the default trace have that information ?

Yes, I need to rewrite my little system scripts.

I use this to search stored procedures. You could search on 'ALTER DATABASE'

-- Find the string 'xxxxxxxxxx' in Stored procedures then select 150 characters that contain it

-- the -25...

SQL Noob (4/6/2009)

---

homebrew01 (4/3/2009)

---

We just tried a full backup with Backup Exec to compare and that took 7 hours. A vast improvement ! With Redgate I had set compression to...

Hi, we're on VMware ESX Server 3.5.0 and EqualLogic v4.0.6