Tom – Thanks for the response. I know there is no cookie cutter answer to my question… I am just looking for some high level opinions/experiences regarding hardware consolidation.

I...

#1 - I can't see where you could schedule the reports to run, but I would download the eval and give a look for yourself. If the feature is...

a little more info...

I can issue an alter statement from QA and from DBartisan (Embarcadero) and everything works fine.

Why is the issue only from Enterprise Manager? I even get...

Strange... I was just going to post the same question/problem with a SQL 2000 server we're running.

I get the errors when trying to change column properties through EM. If...

Thanks Andy - I may look into merge a little more before I rollout any changes.

will do... thanks again for the help.

FYI - we will be using SSL and this is an internal app... the ASP will not be exposed to the web.

Brian - that was a great help... I think I have this nailed.

so... if the user's, IIS and SQL are on the same domain we do not need to pass a user?? the NT sid will be used automatically?

thanks again.

Thanks... that's a big help.

Thanks a bunch Andy! that worked.

Should I change the recovery mode of the backup db now so the log shipping restores will work again?

David - thanks!

Jay - you can get the files here -

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q285100.

There are 2 files, a .dll and .pdb. They need to go into your binn directory after the...

ok... here's the deal. I spoke with MS support today and we were able to solve the issue.

1. Run SQL2000 setup from the cmd line using 'setupsql.exe k=dbg' ...

Karen - I'll keep you updated

Brian - The MDAC thing sounds like a possibilty. I'll follow the links and hope for the best.

Antares686 - Here is all of the...