Check the connections on dynamic properties and check whether there are any orphaned connections...

If you are DTS package works in dev and when u move it to other env then...

capture the

SP:StmtCompleted

SP:Completed

events also in your other trace...

Enterprise Manager->Server Properties->Security->Audit and capture the failed logins and send an email...

how did you rebuild the indexes?

try updating the statistics for the object and see whether u get the same results again...

I dont think you have the last modified property w.r.t objects in the database but you can find out the crdate and schema version in sysobjects tables..

crdate - date of...

It will good iif u can pre allocate the temp db size to avoid autogrow..and set the autogrow in MB instead of percent..

when you right click on the server registration does it display the status icon as running?

If not you might try deleting sql server registration and register again ...(may be u can...

From BOl..

database and transaction log backups works only if you have an unbroken sequence of transaction log backups after the last database or differential database backup. If a log backup...

hope this helps..

http://support.microsoft.com/?id=327322

well i have upgraded to sp4 and applied to hot fix to build 2040 on some of the servers in our env...had no isuues..

right click on server->Edit SQL Server Registration properties->Display SQL Server State in console..

The "Display SQL Server state in console" checkbox allows you to enable or disable the...

If the job owner has admin privileges then it is executed in context of SQL Sever Agent account else the proxy account..

What exactly are you doing in the DTs Package,...

execute DBCC UpdateUsage..

You can execute  DBCC ShowContig to see the fragmentation and page density etc for that object..

Also you can to EM and view the tables and index sizes in...

Is SQL server configured to use mixed mode or windows authentication?

If it configured for windows then check whether  SQL Server Authentication connection is being used inside the dts package..

Else it might...

how much data is returned to the client??

Just to test try top 1 on the data that is being returned on the select and check whether u still see the...