Thanks John,

Although we have the triggers on that tables but i cheked all again we have the same schema where these triggers are inserting actually.

what could be the other...

Thanks, but conflicts have resolved on daily basis. but still some data missed which is also not the part of conflicts.

any possibility of msmerge_contents table having many rows in it??

Thanks,

Noman

Hi.

check the scan density of that tables like

MSMERGE_CONTENTS, MSMERGE_TOMSTONE etc..

dbcc showcontig ('MSMERGE_CONTENTS')

- Scan Density [Best Count:Actual Count].......: 50.44% [26305:33534]

if its too low then reindex it like:

dbcc dbreindex ('MSMERGE_CONTENTS')

it should...

can u help me regarding CLR Procedure for getting the win login.

I shall be very thankful If you can provide me the code.

-Noman

Thanks Karl,

You are right, i want current window login from which i am logged in the windows but i am using SQL with SQL Authentication.

so we cant get this info...

Yes definitly we have set some plan for our future.

but the question was about the past. How can i read my log (ldf) file.????

Thanks, it works.

thanks for your replies, yes you are right i want to do same as you asume. i want performance and want move our history tables into the other filegroup. in...