John,

Thanks for your very helpful reply. I didn't use it 'as-is' but you put me on the right track. To get to the subform, the user has to click on...

First of all, thank you very much for your prompt response.

This is a SQL Server Identity Column.

The table is in a SQL Server 2005 database linked via an ODBC...

Hi, I'm trying to do the same thing. My idea was to force the row to update using an Event Procedure in a control in the form but I haven't...

Nice script! Very helpful when looking for wayward permissions also! Thanks!

Art

Thanks for the reply!

Here's the script of the trigger. The trigger was not changed at all. I just restored the database from a SQL2000 installation.

CREATE TRIGGER [dbo].[trg_STN_ParserCodes_Unique]

On [dbo].[STN_ParserCodes]

For Insert, Update

As

Begin

Declare...

Markus,

you're a life saver! I ran the script and it worked like a charm. Thanks again!

Art

Thanks Markus! I'll check it out.

Thanks, Bob!

Chris, If you create a script of the replication thru Enterprise Manager you can see where you can enter the receiving object name. I've never tried it but it looks like...

Jeff,

The OPTION (FAST x) worked like a charm! Thank you soooo much. I appreciate everyone's comments on this.

Art

Jeff, I tried your SELECT and got an estimated row count of 10 - which is what I would expect. I also ran the following statment and got an estimated row...

Thanks! I ran the SHOW_STATISTICS and now I need to figure out what it's telling me.

The distribution statistics are much more accurate with...

Thanks for taking the time to look at my problem. The problem is with the difference in the Estimated Rows returned by the Execution Plan.

The Execution Plan calculates wildly different estimated rows...

Gareth,

Thank you, thank you, thank you! I've been working with Microsoft for a week on this issue to no avail. Your suggestion was just what I needed.

And, thank you SQLServerCentral...