Have you tried a ROWLOCK hint in your update?

Most likely candidate is MOM (Microsoft Operations Manager) or NetIQ. Are you running either of these?

How about SSIS? 🙂

What build are you running? There are a number of issues out there surrounding the cleanup task. i.e.

http://support.microsoft.com/kb/933508/en-us

You might want to take a look at -

http://support.microsoft.com/kb/937137

or consider using a...

BOL -

http://technet.microsoft.com/en-us/library/ms191295.aspx

Another option - use a System.IO within a script task to populate a boolean variable - i.e.

Imports System

Imports System.Data

Imports System.Math

Imports System.IO

Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain

'Purpose: Determines if...

Came across an article on SSC which should help you if you want to use EFS as an alternative 🙂

http://www.sqlservercentral.com/articles/Administering/implementing_efs/870/

Have you considered a third-party product, i.e. Idera's SQLSafe, Quest's Lightspeed, or Redgate's SQLBackup. All offer support for both compression and encryption.

2008 will offer native compression but not encryption...

LogPI (not sure if this is still available), Log Explorer (http://www.lumigent.com/products/le_sql.html), and Quest's TOAD (http://www.quest.com) are the first ones that come to mind 🙂

Stand corrected - there were so many bugs pre SP2 that I never bothered checking again 🙂

Some third-party products (i.e. Idera's SQLSafe, Quest's Litespeed) will allow you to restore the backup of a 2000 database to 2005 however this isn't an option using SQL Server's native...

Glad to hear it 🙂

Have a look at this blog here - pay particular attention to the perf counters, any leaks?

http://mohammedu.spaces.live.com/blog/cns!6699CF8ADD3D4F67!256.entry

There are several alternatives. Have a look at this article -

http://www.databasejournal.com/features/mssql/article.php/3619166

Store the package in msdb and use the "Rely on server storage and roles for access control" option 😀