Permission issues where not mentioned in you previous post, feel free to figure this out on your own.

You need to enable logging of the package outer and inner to SQL server, best on the server it is running\saved to. You right click in the empty space in...

You can use master.dbo.xp_msver extended stored procedure to gather cpu count as well as a lot of other details. 

I just did the same thing, I used a combination of xp_loginconfig extended stored procedure and osql. I wrote the results of osql to a text file and then queried...

Do you have any foreign kaeys that reference this table, are they indexed correctly. Can you paste the update into another instance of QA and display the estimated execution plan...

I would explicitly convert to the data type you require, I have a feeling sql is implicitly converting.

does the sql service have access to this path?

You could use

EXEC

('DBCC sqlperf(logspace)')

and insert this into a table and get set an alert if the...

Balmukund,

doesn't visual studio get installed when you install SQL 2005, if there was a previous installation would that cause issues?

John,

Not in this situation myself, but saved the web page

http://dis4ea.blogspot.com/2005/07/tempdb-and-missing-device.html

to my docs and this gives me what I need in the future if I get the call in...

Just a few of the querks that I hope get ironed out in the next SP, also watch out for the querk that does not delete old backups from maintenance...

Delete the SQL registration in EM and reregister using the instance name. It is always best to be on the box (teminal in) that is being used as the source.

check msdb..sp_delete_job in bol

Do you have the optimize for many tables option on, if so check this out: http://blogs.msdn.com/chrissk/default.aspx

Jeff,

I apologize, I misinterpreted your post.