Thanks!

2003 standard and 4GB on the machine

Thanks for all the replies and advice. Much appreciated. I'll take a look at Quest's tool.

Your assessment is correct. We want to run the work load as it occurred in production with the pauses.

Thanks for the replies.

I have used profiler to capture data in the past, but have not used it to replay transactions. Quick question: If I capture transactons over say...

I would be interested in your experience (good and bad) with polyserve (PS). We are looking at the solution for SQL consolidation and HA. At present we are...

Not yet. We pointed the process to another server as a work around.

Any resolution on this issue? We just started seeing it.

Thanks for the reply.

Selling the business on performance imporvements and enhancements is difficult especially in a down economy. SQL2000 has preformed well for us over the years and...

Thanks for the feedback. Much appreciated.

I'm thinking that compression will reduce the cost of disk space and tape backups over time, and perhaps eliminate third-party compression software....

Just curious... Did you rollback to SP3a and if so, what was your experience?

I've been away for a few days, but much thanks for all the replies. We have over 500 DTS packages in our environment, so the migration to SSIS will...

Thanks for the Response. Our developers have MSDN licenses, so they should be good to go.

I found my error on the second issue. It appears you...

I have another quick question. If I install a named instance of SQL2008 standard edition on a SQL2000 Enterprise edition server, is it possible to convert the named instance...

Thanks again. Just to be clear, are you are referring to creating a new SQL2008 standard instance on the existing SQL2000 enterprise machine?