Thanks guys....
Nothing in the error logs? strange(At this point I am just guessing I broke it)
The subscriber just disappeared. Added NC indexes and the next day I have no subscriber. I didnt check on the subscriber right adding them.
I deleted the new ones. Created a new subscriber but now I am getting PK Violations on "can not insert duplicate key in object "
At this point , looks like start over.
Going forward do I have to add indexes VIA the publication properties(snapshot/run additional scripts)?
Seems like I should just be able to go to the subscriber and run a normal Create non clustered index script.(could be I never broke it to begin with,unfortunately I am left to assume:hehe:
)