Nice article., Would really appreciate if you can incorporate and put in the functionality of SSIS and Replication within which can enhance the application to a much higher stand.

well there are couple of things that could be done in this scenario

1. Check if the SQL Server error logs show any errors pertaining to the distribution agent

2. try to...

HI,

How frequently do you update your statistics

When was the last time you rebuit your index

If statistics are not updated properly your SQL Server can not give you a proper...

you might have to check the workflow properties to empty the table at the destination if you wish to or change the workflow to use SQL Query where you can...

Yes it's a Double-Hop problem

Basically within windows authentication we have two types of authentications Kerberos and NTLM. In your scenario i guess it is using Kerberos authentication. You might have...

you basically have to set column mapping and set the data type conversion as couple of datatypes as varchar are not availble in Dbase

-Krishna

hi gift,

Yes that is the right way to start troubleshooting.  I appreciate your knowledge on this

- Krishna

I would recommend to proceed and clean up the registry also i would recommend u to follow this kb article for proper cleaning.

Have  a test environement in place and install SP2 on it.

After that configure sharepoint to connect to this installation of SQL Server 2005

Before we can answer any of these questions.  Basically wanted to know what is the version of your SQL Server.

1. What is the version of your sQL server

2. Service...

hello,

How many articles are there within the publication

Also can u script the table

Drop it and recreate it and then add it into the publication

I guess this must work the...

Hello,

Collect the verbose log and check if you get any information from within in.

As this is a pretty generic error.

1. Is it at the time of initial synchronization

2. Does...

HI Daniel,

Just to give you a brief description of how merge replication works

In Merge there is no distribution agent.  This functionality is taken care by the Merge Agent itself.  basically...

Well in this scenario you can as well us the snapshot replication or transactional replication depending on your business requirements.

In this scenarion you can make the publisher- Distributor and the subscriber...

Well can we see if ther are any kind of open transactions

dbcc opentran('<database number>')

and also select * from sysprocesses where blocked <> 0

If there are any kind of open...