Gotta create an account if you dont have one, but this webinar will show you.

http://cms.pragmaticworks.com/videos/default.aspx?VidID=464fe4c05f664a108d7ab7515a96c320

I think you can also run the report 'DiskUsage' for tempdb and it will show you stats on it.

ah, thanks for the enlightenment Ninja's_RGR'us!!!

How about READ UNCOMMITED to avoid locks...

What was the solution ?

what is the error you are getting ?

check it out,

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/3bd72b8a-aa9e-4cb9-8d3c-5a623c026e62/

check this link out.

http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/266cb8be-8c15-4420-a0ad-6dce133cb975/

http://msdn.microsoft.com/en-us/library/ms188611.aspx

'for parallelsim'

http://msdn.microsoft.com/en-us/library/ms190315.aspx

'for scope identity'

IS RPC & RPC out set to true under 'Server Options ' ?

http://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/

This is a good one, there is a link somewhere floating around that lets you order a sweet poster!