I suspect that it is a problem with xp_SMTPSendMail80. I think it is sitting there trying to send the email, and it never actually fails, just keeps trying. SQLMail has the...

An excellent point!!

What is the DTS Package doing? What is the first task?

You need new developers.

Sorry, I never did get British humor!!!

(just kidding, I love Benny Hill!!!)

For me, changing jobs has been a great stress reliever. I left a company where I was wearing many hats (DBA, SQL Developer, backup systems admin, managing the data team...

Windows built-in Task Scheduler works great for scheduling and running DTS packages via the DTSRun utility. It even allows you to specify the Windows account to run it under. This...

Just for a surprise gift.

Well, my wife got me front row seats for the Dallas Cowboys / Seattle Seahawks pre-season game on Saturday (right behind the Cowboys' bench), so now we're even.

Brilliant!!!!

Also to note, a diamond ring is a symbol of love, eternal and perfect. A tv is a symbol of laziness.

So what are you trying to tell your prospective mate?...

I don't know if it is still true in SQL 2005 or not, but it is still true in SQL 2000.

Unfortunately, I can't see your package from here. Can you describe how it is set up a little better?Perhaps even include a screen shot of the package in DTS Designer.

Just a note about building CLR functions. T-SQL is still the native language of SQL Server and processing T-SQL functions is a lot quicker than CLR functions as SQL Server...

The Exists clause is a lot faster than the IN clause for a very simple reason. With an IN clause, SQL Server gets the entire dataset returned by the query...