You have a few choices. You can schedule the replication agents to run automatically. You can obtain the job name or job id of the replication job(s) and...

If you want to pull other columns, then you will be getting more than one row for each ID. Is this what you want? In this example, ID...

select ID from (select distinct ID, FT from Test where FT='F' or FT='P') Test2

group by ID having count(ID)>1

Is this on SQL 2000? I struggled with this very thing just this past week on SQL 2000, and found that on the client side path you have to...

The SQLServerAgent service is the "user" that performs the replication, not the user that's logged in. Make sure that the account assigned to this service has the correct permissions...

Oops. I just realized that I forgot to remove the equal signs in the OrderID comparisons. With the equal signs, the page returned includes the "current" row. ...

Before I start, let me state that I'm not criticizing your code. I'm just pointing out how it doesn't fulfill the requirements of my applications. I had intended...

Andy,

I agree with you - set based solutions are usually better than cursors, and I wasn't calling your solution a 'bad' one. I'm just relating from experience that when...

Andy,

The goal of the original procedure was to present a list (or browse as I call it) of certain columns that can be sorted by any of the columns, and...

Are the two Identity functions connection specific? In other words, if another user/process adds a record between the time you add a record and the time you call the...