I have a standard test as well. I had an article on it (maybe still do). I used to get some really funny things as well.

What was really amazing to...

Be interested to hear. We have been all W2K except for the PDC/one BDC for over a year. We love 2K, but have been hesitant to take on the migration...

The Bell Curve just shifted again!!!!!!!

Steve Jones

steve@dkranch.net

memory leaks are this biggie. Load is another. This is overhead that is better spent somewhere else as your server gets busy. I'd hate for my database server to be...

I'd recommend DTS, but I used this with SQL 7 early on in its life.

Script out all objects from v6.5 (EM does this)

Run script on new server

Had script to BCP...

Whew, not sure if you can get the db without the log.

I think you need to recreate the database with a blank file (using the GUI). Then shutdown the server...

I like the article. We need a standard view of our jobs for it to be more accepted in all industries.

I think that the production DBA should report to an...

I'd always leave it to users to change things, but try to standardize whereever possible for storage. especially for loads of data from an external source.

Steve Jones

steve@dkranch.net

I think you need 3 environments at a min. Prod, dev and a QA/staging area. Refresh QA and test before moving changes to production. Reffresh dev rarely and be sure...

sp_recompile forces the procedure to recompile when you run it and a new query plan is built at that time. We were thinking the query plan is out of date...

glad we could help.

Steve Jones

steve@dkranch.net

Post your code and we can help, but Leon is right. Get it working in QA first.

Steve Jones

steve@dkranch.net

Don't use sa in DTS!!!!!

You might need to re'save your DTS packages. I see them sometimes flip out with changes like this.

Steve Jones

steve@dkranch.net

I would add that most people stink in this business. I think the curve for IT people (especially DBAs) is bent to the left.

I'd be interested in knowing how he...

Sounds like you are missing something.

Can you try another machine? (Another copy of EM)

Steve Jones

steve@dkranch.net