Hi all, I am hoping someone can answer this question. I encountered an exact issue described in MS KB http://support.microsoft.com/kb/934188/ I have requested a hotfix build 3161 from MS, but I have a problem regarding where to apply this hotfix Should I apply to the distributor or to the s...more >>

Hey guys, I have a a problem was wondering if someone can pointme to the righ direction. We have two SQL server running on WIN2k3 and sql 2005. At the moment we have replication setup between server 1 and server2 but it doesnt work. The replication is setup that Server1 is setup as publi...more >>

Hello! We currently have a publication to a single database that we had to set the subscription period to "Subscriptions never expire". This change was made about 1 year ago due to the following error: The Merge Agent failed after detecting that retention-based metadata cleanup has dele...more >>

Can I detach and attach a database that is being replicated to or distributed to meaning Subscripting Database. Thanks ...more >>

For the life of me, I cannot figure out where to change the replication connect string to the subscriber from named pipes to tcp/ip. On the publisher, I have the subscriber registered in SSMS using tcp/ip and it connects just fine, but the merge replication syncronization fails each time be...more >>

I am not able to create publiction. It gives me error-- Invalid Object Name dbo.sysmergepublication does not exist Publication EmpPublication does not exist change database context to 'Emp'(Microsoft SQL Server, Error:208) ...more >>

Hi, I had setup a merge replication. After some days when I checked the synchronization status it was saying the subscription to the publication <publication-name> has expired or does not exist. Can someone point me why any subscription to any publication expire. I dont remember there is an...more >>

Hi, We are planning to create a replication for a new system with Sql2005 server I would like to know if there are some field type that we should not use For exemple in the Employe table we are planning to use a binary field to encrypt the password of the employe. Should we use this type of...more >>

I am setting transactional replication from sql 2005 to sybase using Sybase OLE DB provider and T-SQL scripting. I need help in defining these parameters: @subscriber_datasource @subscriber_provider @subscriber_providerstring @subscriber_location @subscriber_catalog Thanks very much dk ...more >>

When I run the SQL Server CE 2.0 snap in through Programs -> Microsoft SQL Server CE 2.0 -> Configure Conectivity Support in IIS. The screen opens and I can then configure the virtual directory , however subequently when I click on the tabs within the confg screen i get the following error mes...more >>

I'm trying to setup merge replication and am running into the following error during syncronization to the subscriber: Named Pipes Provider: Could not open a connection to SQL Server [53]. On the publisher, I can register the subscriber via tcp/ip without issue, but the Replication-speci...more >>

Hi guys, I have two servers at different locations (connected over the Internet), and I'm trying to enable replication between them. I have had no issues enabling replication over a LAN, but reproducing the same steps over the Internet does not work for me. I have been able to create a p...more >>

Hi all, I got this error when the snapshot agent run after the setup of the subscriber. How do I resolve this? Error messages: Message: StartIndex cannot be less than zero. Parameter name: startIndex Command Text: select 'number' = convert(int, 0), 'definition' = definition from sys....more >>

I have a setupwhere the Publisher cannot communicate directly with the subscriber, but the distributor can communicate with the publisher and subscriber. It is possible to push/pull a subscription to the subscriber in this situation? ...more >>

We want to move distribution database of a SQL Server 2000 instance on to a SAN-based file-system without dropping & re-implementing the replication processes between this publisher instance & its subscribers. Is there a way to do this? If not, could we achieve our goal by setting up a new SQL...more >>

Hi All, Does any one know which stored procedure can change Distribution Agents PollingInterval from default 5 minutes to 1 minute in SQL Server 2005 (SP2)? I am using push right now. Regards, Chen ...more >>

The setup is Microsoft SQL Server 2005 as the publisher for transactional replication to an Oracle Subscriber. There are some not null columns that have empty strings in them and when it gets to the Oracle subscriber it is being translated in to null and causing an ORA-01400 (cannot insert nul...more >>

good morning! my replication fails: Insert Error: Column name or number of supplied values does not match table definition. I know it's a procedure casing the problem, is there a way to identify the procedure causing the error? if NOT is there a way to bypass the error? thanks, Mark...more >>

Hey guys, i need help. I tried to remove a table from a transactional replication in sql server 2000. I guess i did it wrong, here are the steps i took: EXEC sp_msunmarkreplinfo 'table_name' sp_dropsubscription @publication = 'my publication , @article = 'table_name' , @sub...more >>

How can I delete subscription information at the subscriber one I delete the subscription at the publisher? Thanks, ...more >>

Dear All Immediate assistance is needed I have MSSQL 2000 I have made a merge replication, and this has gone pretty successful. But something has happened to my database. Some of the databases on the server is marked "Suspect", and I can't find anything in the help to advice me what to do On...more >>

Hi everybody, I have a DB merge replicated between 2 servers, both SQL 2000, the first is publisher & distributor, the second is a subscriber. I need to add a column in a table that is included as an article in replication. Which is the correct mode to proceed for adding the column? Second q...more >>

Hi I have one more qustion. If I have a merge replication and I remove an article I have to run the snapshot job. But the customer has a lot of data in the tables. Is there a way to make the snapshot go faster. The guy responcible for setting up the merge replication told me that the snapsh...more >>