Thanks bro. It's supercool.

Greatly appreciate your help :-):-)

My question is can we create new publication in P2P or we need to use already created publication all the time for adding new articles.

Initially,i have setup the P2P replication by taking backup and then restore them to other TestServer. But can i add new publication or i just have to use existing publication...

Thanks for reply.

Can i create new publication and put table into newly created publication.

My only concern is when i configure Peer-To-Peer Topology there is an option,

Specify how the new peer...

Can anyone please reply?

I have dropped the statistics using script

drop statistics table_name.statistics_name.

And check again using

sp_helpstats table_name.

Anyway this problem has been resolved.

Thanks for your time.

Thanks everyone.

Issue has been resolved.

This has been resolved now.

preetham gowda (4/10/2012)

---

See if you can change the dataType from char to varchar and update the coulmn by trimming it.

I did try converting Char to Varchar but getting the same...

I have provided sample row in previous thread.

That's actually one of the same thing. But can we put it into one single query rather then 5 or 6 different query?

Here are the list of columns:

SELECT DISTINCT a.keydoc,

a.keyfreesiteaccess,

...

Users want to simplify the query for their need.

My original query was consisted using 5 different temp tables.

@KeyDoc int

select distinct x0_0.KeyDoc,x0_0.KeyFreeSiteAccess,x0_0.KeyFreeSiteAccessOverride,x0_0.KeyFreeSiteAccessPublishable

INTO...

iam777here4u (3/9/2012)

---

Try this, it may contains syntax error. I don't have a context, so this is just a wild idea. We need to optimize this. Try and let me know...