SQLZ (3/18/2008)

---

Balakrishnan K (3/18/2008)

---

Hi all,

Gladly welcome your advices / suggestion to have in mind before truncating log file of a Replicated database running under Merge replication. I need to truncate...

omg, I just figured this out!

a noobie mistake, I can't believe it!

the critical indicator in relication monitor is ultra sensative, you can change it to be less. I never care for those indicators as long as i'm pumping 100+ commands...

can you not get the data and have it replication both to your 2005 and 2000 server.

use your 2005 server for testing while your 2000 keeps plowing thru.

that's a cop-out excuse. Why are u even trying to defend yourself to a manager or a vp as to why a system is crawling on its knees?

Why should...

images and everything works...

it is a viable solution and it doesn't take a lot of work. If the users aren't in the approval list, then when their long running query hit or...

why not do the following:

write a code to check for duration of a query and if it doesn't match a certain group of users, that spid is killed. The...

1) locate all SQL servers which is easy to do by running 'osql -L' at the command prompt and pipping it to a text file

2) bcp that txt file into...

glad I was able to help.

you are just trying to get rid of the distribution database right?

open up object explorer, right click on the replication folder, and select 'disable publishing and distribution'

That will...

Hi,

Thanks for looking into it for me. I have verified that both tables are the same. I used a script and ran it on both servers.

I just went...

figured it out by unchecking the compression tick box :sigh:

that wasn't my question ...

I have already scripted out everything, by hand. I can't find any t-sql code to create a new distribution agent. The distribution property...

for such huge amount of deletes,

try using a sproc. set it to execute store procedure. for more information:

http://technet.microsoft.com/en-us/library/ms152754.aspx