Nope - ended up doing it manually

Excellent - thank for the info !

No not yet, the max memory is not set either. The DBAs say they are contacting MS to try and figure out the issue. One of the other posts on...

We only have 20 databases on our server and we are getting the memory and timeout errors.

SQL Server 2005 64-bit

64gb ram

We started applying step 1 in http://support.microsoft.com/kb/918483 How...

Dito I choose D also since that was the only one that met the space and cost requirements. If I would of had the option they posted as a solution I...

Basically I want to support our customers as best as possible. The servers would more so to ensure the response times globally are adequate as opposed to disaster recovery, if I...

Thank for the response.

"If you cluster, your machines should be located near each other" - Clustering is out then unless we simply cluster here in...

At least on SQL 7.0, not sure about 2000 or 2005, you can go to managment, current activity, locks / process ID and see who was locking and if you...

Arer you specifying the owner of the sp when you executing it? If the owner is something other then dbo you need to include it.

Other thought is connection used to the correct db?