And also bear in mind that the slowest thing in your DB server will be your disk(s).  So the duration includes the time spent waiting on data from the disk...

To make things efficient, try rewriting to not use a cursor.  I'll have a quick shot at it now...

But.  When you say "eliminate all duplicate records that occur within a...

By granting a user the rights to execute a stored procedure or select from a view, any objects accessed by the view/SP are accessed using the rights of the view/SP...

Any options for some sort of event driven queue - ie, when a message is received, SQL will call a stored proc?  Kind of like a trigger I suppose.

Sounds very...

Yeah, we do the temp file thing for our doc management app...

But for some apps that accept a http:// URL, you could always shellExec the URL and have the app...

That's because you don't need to care so much - the replication will work regardless of if or where you have a clustered index, or any other indices for that...

As others have said, you should use the "inserted" table in your trigger - it contains the new rows of data being inserted.  Then you could just update the rows...

I very much agree, just another tool in the belt that may come in handy.

Excellent article - one of those technologies that I've not had any experience with, have read about and wondered even more and hoped that if asked something about it during...

That would be something you would do on the client side...  What client-side interaction is occurring?

Perhaps you want SQL to raise an error and pass a message back to your...

The sa account is only available on MSDE if you used

securitymode=sql

when installing msde from the command line.

Actually, come to think of it, you will also need to have specified

disablenetworkprotocols=0

on the...

What about things like set options that are active when you are running in QA vs the environment modifying the table causing the trigger to execute?

Also, perhaps the use of...

Couple of Q's   

1.  Could you please post some example SQL code?  What TSQL construct are you using to access the remote data?

2. I...

I guess that it is something that Joe Celko might say, but an index is a performance boosting concept and might influence how SQL Server executes your query, but should...

OSQL and ISQL are pretty much the same - one uses ODBC and the other uses DB-Library to connect to SQL...  I've used osql out of habit