Viewing 15 posts - 211 through 225 (of 307 total)
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...
February 19, 2003 at 9:51 am
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...
February 14, 2003 at 9:22 am
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...
February 14, 2003 at 8:28 am
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,...
February 14, 2003 at 8:02 am
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...
February 12, 2003 at 1:25 pm
I'm told a lot of the finacial software packages install MSDE, ScottTrade, Ameritrade, Foliofn, TDWaterhouse maybe Quicken.
John Zacharkan
February 12, 2003 at 9:07 am
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...
February 12, 2003 at 8:29 am
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...
February 11, 2003 at 10:46 am
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.
February 11, 2003 at 10:32 am
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...
February 10, 2003 at 11:31 am
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
February 5, 2003 at 1:33 pm
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...
February 5, 2003 at 9:50 am
Why don't you run the package on the DMZ server through a job on a server in the local network then.
John Zacharkan
February 5, 2003 at 8:22 am
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
February 4, 2003 at 1:06 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...
February 4, 2003 at 12:01 pm
Viewing 15 posts - 211 through 225 (of 307 total)