I have had this kind of questions in the past and the answer has always been (so far) transaction handling code overhead is negligible!!!

Just my $0.02

Take a look at sys.dm_tran_locks

You need to use Kerberos to pass Windows account credetials From client-to-server-to-server. (If that is what you want you should configure the linked server for delegation )

hth

If you are going to use the "copy" to new table method I would use "SELECT INTO..." instead of batches of inserts.

ALL these activities will require heavy I/O anyway....

Although not very well documented 😉 you can launch "Job Activity Monitor", highlight the grid, then Ctrl+C (Copy). Then on Excel do Ctrl+V (Paste)

Cheers,

Andy Leffler (5/1/2008)

---

So this solution would not be a good solution for someone looking for a reporting server since it does not A) terminate all connections to the database prior...

Parsing is, in my opinion, client-side responsibility. Doing these kind of things is SQL Server is not impossible neither difficult but I tend to pass that to specialized languages that...

Otis (2/26/2008)

---

Right I need to be able to use my database copy whilst the replication is in process.

Am I right in saying that Transactional Replication is the only way to...

Jim Mace (2/28/2008)

---

The last time I tried a backup/restore a ran into some incompatibility issues between the two versions of SQL Server and my database. Is there a way...

You probably don't have SP2 installed 😉

One thing you have not mentioned is how much bandwith do you have available

backup and restore is the "safest" path.

In addition repair "with_allow_data_loss" may NOT repair and may even get things worse!!!

As far as I know to INSTALL SP or HotFixes you do need local admin rights 😉 There are also registry settings that are not commonly changed but that could...

Loner (2/15/2008)

---

I have a table that has a description column using NVARCHAR so I can put in description in any language.

When I put in data in different language in that...