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

After upgrading to 2005 I ran:

EXEC sp_dbcmptlevel @dbname ='DatabaseName', @new_cmptlevel = '90'

.

dbcc updateusage ('DatabaseName') with count_rows

.

use DatabaseName

.

exec sp_msforeachtable 'alter index all on ? rebuild WITH ( FILLFACTOR = 95,...

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 '0', but it...

Restricted growth means it will grow up to the size you set. So if your file is 90 Gig, and restricted is set to 95, it still has 5 gig...