How do you know it isn't enabled. Lots of SQL 2005 features use Service Broker under the hood.

I think that it gets closed when the Target closes it, but I am not sure. Why not just test it and let us know?

oops, I think I misread the question. :blush:

Excellent choice. I wish more people who ask that question had your good sense. 🙂

I've always had the impression that Triggers had more overhead and would be slower than stored procedures. Of course, depending on how long this Excel File work takes, it...

The only way that I know to do it would be to modify the stored procedure to either 1) use the SET ROWCOUNT command (deprecated, I think), or 2) use...

It just leaves the conversation open, which in theory can be used by other senders (if they know the conversation handle).

The only bad things, AFAIK is that if you are...

Is it just me? Or is this just some cultural thing? ...

Duplicate post. Please do not cross post.

Direct all replies to this thread: http://www.sqlservercentral.com/Forums/Topic762905-149-1.aspx

Here's a naive implementation of the Path-Only model with your data that demonstrates it's advantages:

create table Binary_tree (PathKey Varchar(30) primary key,[Name] varchar(20),Age int);

INSERT into binary_tree (PathKey, Name, Age)

SELECT '','A',21

UNION SELECT...

Binary trees are also particularily good candidates for the "Path-Only" model.

That's because you are executing as stlntdom\jsmith and you have not given 'stlntdom\jsmith' access to go through your linked server.

???

Weird. I cannot figure how this would make any difference? Nothing wrong with you code, Lowell, it just shouldn't fix a "non-unique" problem. ...

Are you calling any custom assemblies or are you using SQLCLR anywhere?

You get the same...