Thanks Steve. I still have the time to request the boxes I will need for DR, so I am not taking any chances, but wanted to have that question under...

Thank you

Thank you to everyone for their input. Rebuild the indexes is a maintenance tasks and it runs weekly. Memory difference? That might something else. I have 1.5 of RAM in...

Thank you. That is something I haven't check or done. Will try tomorrow. Thanks

Thanks, I refresh test to have the most current data (difference is just from 11:30 AM to now)

The statistics were the first step to optimize the query. Indexes were also...

Thanks, all done already. Production server has 8 CPU's and 4 GB of RAM, maybe add more memory and enable AWE Running sp_who2 and perform mmc, I am not getting...

Good catch and good luck 🙂

Sorry, I forgot. No restart is required.

yes, tracey. The connections stay up as long as the staetement is running. After that they will be closed. You will see them a little bit longer after the statements...

Hi and hope this helps. Set the query parameter at the SQL Server level to 0, which will all queries unlimited time to run. I agree with the rest of...

Greaat, thanks to all. Will rerun SP2 then.

In any event, the error I am getting back is that @binvalue has been declared already. The script was taking directly from Microsoft as well as from the stored procedures...

Thanks, All servers are running in Windows 2003 Enterprise and all my sql servers are 2000 sp4. Why it works on almost all of them and not these two???? Who...

try using db2 driver. I worked for a while with SQL Server and importing data from an AS400 into SQL Server and I used DB2. Just an idea good luck

With that in mind, all your departments and rights prior to set the roles, you might think of setting Windows authentication. This will allow you and your systema admin to...