What OS? Is it on a cluster?

SET XACT_ABORT ON

BEGIN TRAN

insert into linkserver.db.owner.table

END TRAN

is that what your transaction looks like?

Wes

You can connect via QA and it works just fine. They are pushing developers to use the new visual studio that is comming out when 2k5 does. That way you...

I would say this is almost the jump made from 6.5 to 7.0. Many, many new features the TSQL enhancements alone make it worth it. Online index rebuilds, oh...

I have personally never done replication to an oracle database. I know it is supported I don't know if the default microsoft oledb drivers are enough. I would take a...

version 3.0.123 until the released the new 3.1.x line had major issues. We are still running 3.122 because it is pretty damn stable. I'm running the newest version on serveral...

Why go anywhere else? the script library here as a ton of good stuff for backups and restore.

Wes

On our most active server I do weekly fulls nightly diffs and tlogs every 15 minutes. I've never had a problem at all with the schedule. I've been running that...

Merge replication would be the only way to do this without going to a third party or home grown solution that I'm aware of.

Wes

Are you trying to pull back all 3.6 million records? If not check your indexes for sure. As the guy above said you may want to issue a nolock hint...

Same here though I can tell you that 818 is the most stable patch out right now and wouldn't move to another patch unless its to fix a specific problem....

What version of SQL Server? SQL 2000 has its own snapshot generation that is pretty robust and doesn't use DTS as far as I know. If you can post some...

I have a script in the library here that captures all logins and dumps them to a file without using DMO. We have recently uncovered a DMO leak when called...

Your method will start falling down if you want to do more than one tlog a day. There is no reason to backup the tlog then backup the database full....

multiple IP's and routing can be an issue. Thats why I recommended killing one of the NICs and maybe adding an entry into your host file on the windows machine...

I can't find where you can tell windows or SQL to use a specific network path for SQL server. Also, the server doesn't know to look for the UNC shares...