Hi all,

I'm experiencing a problem on a script based copy for linked servers.

The steps are, for each entry on remote sysservers table:

1. Drop the linked server (and its associated logins)...

The ideal way to "unsuspect" your database is running sp_resetstatus against it. Immediatly after that, stop/restart your instance. Instead of this restart, you can try a detach/reattach of the database...

Thanks for the SELECT INTO tip.

It looks like CREATE TABLE statement requires only EXclusive locks, whereas SELECT INTO requires EXclusives AND SHared locks, and that is what created the deadlocks.

The...

There is no need to have a lock escalation in order to get a "good" deadlock.

Since (I guess) system tables have no Cluster Index, newly inserted rows are on the...

Hello,

I won't give any financial preference, but there are some points to considere:

Soft Raid is by far slower than Hard Raid, and it might corrupt your datas in case of...

There is also a fragmentation effect with Oracle, because the allocation unit, called Extent is variable size. a process is running while a base is "up" that online defragments the...

I don't have a huge experience in both Oracle and SQLSERVER, but I think that there is some relevant differences that should let you make your mind:

First of all, I...

OK.

So I give up gathering informations about SS65 perfs, and I focus on SS65 designed clients connecting to SS2K.

Thanks.

Benjamin

Thank you for the advice, but I'm afraid I can't afford to use SS2K: Lot of different clients that use the DB-Lib, or old MDAC, and I can't even think...

Thank you.

Actually, I know NT4 is to be Enterprise Edition (in order to manage the 8 procs), and W2K will be Datacenter Edition (the final architecture will include a geographical...