gail then wat shud i do... i thing i cannot run this sp on subcription database

Hi Gail,

This might happen due to conflicts happens some time mainly in this subcription database ... due to which it might showing transaction still pending while truncating the log....

Can...

gail ..

its a subcription database ..... and a live database

we are using sqlexpress edition for subcription database

hi gail

... this is the output from the dbcc commands....

Transaction information for database 'B8017'.

Replicated Transaction Information:

Oldest distributed LSN ...

hi gail this is what i hav got from the sp s out

sp_replcounters

database

replicated transactions

replication rate trans/sec

replication latency (sec)

replbeginlsn

replnextlsn

sp_helpreplicationdboption...

gail it is not giving me any result

gail it is showing sucessfully complted ...

plz provide me the suggestion

plz reply

Try this

Select Cnt as Count1 from (

Select 10 - (Img1 + Img2 + Img3 + Img4 + Img5 + Img6 + Img7 + Img7 + Img8 + Img9...

check out the blockings and use profiler .... counters

still waiting for the reply.

gail we r having merge replication implemented .... actually wat happen is some one changed the recovery model to full and then changed it to simple so this might be...

yes gail replication is working..

.... gail few week back my data twice got currpted

............ so i have runed dbcc checkdb thrice in two weeks..

can i switch my database to...

hi gila wat need to be done if there is a clustered index create on a column and see index scan....

waiting for the reply.......