What steps were taken in the development environment to test the performance?

When did the problem start?

Is the performance issue consistent or intermittent?

Are the disk fragmented?

Is the Database fragmented?

Do you have...

In the Event Viewer you can Filter on the Event to narrow the Events to Sql Server Event Types.

You can also do the following:

http://social.msdn.microsoft.com/Forums/en/sqlnotificationservices/thread/402f01cf-9ee1-4f7d-a901-c0743bf1e85a

Check permissions.

Check out the following:

http://www.microsoft.com/events/podcasts/default.aspx?seriesID=Series-11bc7f7b-77a6-4e18-ac58-6c9cfbe102aa.xml&pageId=x6234

Check out this article:

http://msdn.microsoft.com/en-us/library/dd392015(v=sql.100).aspx

Check out the following:

http://social.msdn.microsoft.com/Forums/en-US/sqldatawarehousing/thread/9b9f5812-400e-42aa-95b6-eacc03381272

Check out the following article:

http://sql-server-performance.com/Community/forums/t/19114.aspx

You got me, LOL. 🙂

Removed Post.

Can you delete the job?

The following thread may be helpful to you:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98114

What is your defaut Database?

Check out this article:

http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx

You could test like GSquared did and you will find out.

I can't get to machine that I can test at the moment or I would do it.

Regards,

Welsh

Browser continues to hang, sorry duplicate post.

Try the following links:

http://msdn.microsoft.com/en-us/library/aa176253(v=sql.80).aspx

http://www.sqldts.com/234.aspx

http://www.dotnetspider.com/forum/280871-Capture-error-message-DTS-package-SQL-task.aspx

http://www.bigresource.com/MS_SQL-Exec-SQL-Task-Capture-return-code-of-stored-proc-not-working-4n1HKZEs.html