I haven't seen this problem, nor I used it in 2K.

Try to set log shipping up from scratch on the problem server, shouldn't take more that 10-20 minutes.

When...

This may sound extreme, but if it's a production server, if nothing is screaming out at you I would rebuild the box. Detach the databases hope fully they are on...

In other words when you installed SQL 2K you didn't set Unicode collation to be the same as you did under SQL 7. If you want to be educated on...

According to the link you gave and to answer your question, "maybe". And I quote:

"If you configure SQL Server to use more than one processor on a multi-processor computer,...

Licensing not an issue here, don't want to touch verions, getting them to migrate, convert 100 + database with full regression testing is on the table. But just because...

I'm told a lot of the finacial software packages install MSDE, ScottTrade, Ameritrade, Foliofn, TDWaterhouse maybe Quicken.

John Zacharkan

I have not only run multiple instance of Oracle, but multiple versions on the same box along side SQL Server 7.0. I cannot speak for 2K, but I don't see...

Haven't done that yet but, I've had problems with the registry with 6.5 / 7.0.

The uninstall in 7, didn't cleanup the registry and I couldn't put 6.5 on. (Completely...

Thanks for pointing that out Brian. I'm so up to my neck in 7.0 servers I sometimes forget about the 2K release. I'm dead when they release Yukon.

The great thing about the the northwind database is it gives you a place to try things out. If your stuck your stuck, glad to help - but, you'll be...

Allen - would you expect to see a rise in cpu utilization after making these changes. Average page split is around .900 with a max 5.039

John Zacharkan

Instead of checking first than updating - why not update check for error not found and then insert.

Also, Insert the row immediately, instead of first selecting, then inserting. The...

Why don't you run the package on the DMZ server through a job on a server in the local network then.

John Zacharkan

Stop you lost me at situation.

Answer: Yes, Mike.

Of cousrse I had to go test it before I said that.

John Zacharkan

Edited by - zach_john on 02/04/2003 1:07:26 PM

I don't explitly use transacations for situations like this.

I traditionally use an Identity column instead of the Max variable, ie.

insert into table ...

set @ThisId = @@IDENTITY

-- This is what I...