I've had a similar issue in the past. I had to :

-truncate subscribe table

-import data from publisher

-restart replication

Good luck!

that's pretty much my point and the editor's. they are not no-no's.

this thread is great because it proves the editor's point exactly!

there are times that you should use the 'no-no's!

thanks folks 🙂 glad to hear i'm not way off-base!

sages be damned.

I don't know:hehe:

I'm a web programmer and I'm doing all I can to get up to speed on DBA stuff. What IS the correct architecture to use?

Is...

This is a highly important service that has two peak seasons. It displays property tax information for the county. A similar web app also displays public records. ...

Thanks for that bit of feedback. I'm learning 'best practices' as I go along. I've inherited an environment setup by the previous guy and things were done so...

What's wrong with views?

BTW, I'm new to the SQL Server world and EVERY MORNING I sit at my desk for 20 mins and read the latest issue in my inbox....