Hi. I have a publication of a database. On some point, i would have to Restore the initialization database (the database in its first state). How could I restore my database without dropping the publication? I have 2 choices. The first, wich no work, is to restore the database and the sec...more >>

Hi there Is ist possible to configure an replication via FTP without any traffic through port 1433 (agent traffic)? I use Microsoft SQL Server 2000. Thanks Roland ...more >>

I have a database named adTempus with a publication (and distributor) on wpg-apps-87. I have a pull subscription on wpg-apps-88. I need to drop the sub & pub and recreate both. Both wpg-apps-87 and wpg-apps-88 show no publication or subscription, however, when I execute sp_dboption 'adTempus' ...more >>

Hello, I have a transactional replication set up and I want a trigger on the destination table to fire on all every row when I reinitialize the replication. How do I make this happen? Right now the trigger won't fire during the initial load of data, but after that it works fine. Is there ...more >>

1) For some of the DDL changes (changing null to not null for example or adding an index) in a table forTransactional Replication, I have to first drop the subscription and publication, make my changes and put publication and subscription back on. This results in a new scheduled job. How can I...more >>

SQL 2000 with SP4 what causes a network I/O error which kept the data from reaching the workstations?...more >>

Hi, I've setup web merge replication, but I've problem when the subscriber is behind proxy and the user running replication is not Administrator on the subscrier machine. When the user is in the Administrator group, synchronization works ok without additional steps. But when the user is no...more >>

Hi, maybe someone can help me with this one. I need to find out via T-SQL whether a specific database is a subscriber of a merge publication. The publisher might not be available when querying this. I would have expected bit 4 (value 8) of master.dbo.sysdatabases.category to be set; howev...more >>

Hi all I have a problem !!! I use a Merge replication between 2 SQL Servers (I try with PUSH or PULL Subscription but same problem) Each morning in the server A I have scheduled an Import from exterenal data ( I make a DELETE all table and INSERT al data each morning) After I schedule the cre...more >>

We are using SQL 2k with SP4. After I used the 'Create and Manage publication wizard..' to create my transaction replication (I took the default settings), it finished successfully. When I check the database listing in EM, the 'distribution' database doesn't show up in the list but the ph...more >>

Hello I have an applicatiuon on a pda where i can synchronize the pda with sql server 2000 When I start the application on open the synchronize window i have to enter a user id and password. repl.InternetLogin = userId repl.InternetPassword = Password I start the synchronization and i...more >>

I have a bunch of portable machines on which I do development, and I was wondering if anyone has any great mechanisms for doing synch between all the machines. Any preferences? I looked at pub and subscribe, but it seems needlessly complex for this as well as the fact that any of the databases...more >>

Hi, This is the situation: We have a large in-house database. It has quite a few tables, some of which contain in the order of 8 million records. This is our production database; the result of all our internal systems. Now, we want to make some of this data available to our clients via ...more >>

hello all, I created a view and I want the result set(records) of the view to be replicated to another server. i've tried replicating the view by checking the view in the replication wizard but it seems that only the definition of the view is being replicated. Is there a way that i can full...more >>

Hello I have a table lets say Accounts with 2 fields Account_id and account_name and another table called AccountAddress with again 2 fields Account_Id and Address_Id. As you can imagine the Account_Id of table Accounts is linked with Account_Id of table AccountAddress. Now if a replicate m...more >>

Can a subscriber, using SQL Server 2005 Mobile, make different subscriptions to nonoverlapping partitions on the same publication, published and distributed by a server using SQL 2005 Server Enterprise? ...more >>

Hi there, I have a replication between servers that is failing with the above error code... can anyone give some insight into why this is happening? I'm replicating from a SQL 2000 server to a SQL 2000 cluster. The verbose log is too big to dump here so I have only supplied the end bit of the ...more >>

Hi I have a problem where a replicated database has been restored onto a different server without any replication. When I try to shrink the log I get the error below The log was not truncated because records at the beginning of the log are pending replication I have tried to detach th...more >>

Hi all, I am looking to develop a handheld device that requires online and offline data synchronisation with a central SQL server 2000. I have been reading up on SQL merge replication to implement this functionality. Has anybody implemented this type of functionality before and if so how did ...more >>

Hi... (sorry for posting to multiple groups but not really sure where to post this one) I'm not a SQL DB by any means and recently played around with some perms in the DCOMCNFG tool. Basically a push replication job was timing out when trying to push content from one SQL server to a cluster se...more >>

I have 2 server for Development/testing purpose, which are again set up for Tr. Rep. my question is as i am going to restore Database from Production Server to this Dev/Test Server. do i have to re-initiate/refresh any agent. So that replication process kicks in & replicate the Database that ...more >>

I'm using the wizard to create a trans. replication. When it tries to retrieve the tables to publish I get this error: New Publication Wizard encountered one or more errors while retrieving the list of articles on 'production'. The list of articles may not be complete. Invalid column name 'o...more >>

I have to create a merge replication system between two DB. I want to know how to use the SQLMerge ActiveX: with this control can I configure a merge replication, or I need to use before the replication management of Enterprise Manager? This is my first time using the replication methods, every ...more >>

Hello all, Just an add on to the previous question. Can a table be set for merge replication and transactional replication? All my current tables are be 'merge replicated', and i want them to 'transactionally replicated' too. I want to avoid having create a snapshot at all costs. Re...more >>

Hello all, We have merge replication setup between 3 servers. SQL1, SQL2 and SQL3. We have installed SQL2005 on a ReportingServer and want to be able to popluate the database on SQL2005 with data from SQL1. How can we set this up? We want to avoide setting up the whole replication proce...more >>

Hi, I wanted to delete some databases used for replication. When I tried to delete them above error message was displayed. I used the the following SPs and then deleted the databases : sp_dboption 'databasename', 'published' , 'false' go sp_dboption 'databasename', 'merge publi...more >>

Hi experts, I am using merge repl, in SQL Server 2000. 1) Is there a ready-made "Microsoft SQL Server Publisher Always Wins Conflict Resolver"? There is one for subscriber, but not one for publisher. Need that as I just want to "broadcast" the data, and don't want any subsriber to accide...more >>

hi all, i m new on Sql and i have a project related to C# and Sql. i have to do a project which must work on LAN, and there must be only one database file on main computer(Server Computer) and other computers(client computers) must connect database on main computer. i m preparing my proje...more >>

I am going to add 3 new fields & going to Modify 5 existing fields on existing tables(articles)on Publisher side. after adding those fields, i need help how i can refresh replication that will bring new fields in effect & getting replicated on subscribers. Any help will be appreciated....more >>

Hi, Am planning Merge Replication for High Availability. 1. Keep an additional server with same configuations. 2. Create a Backup of the database and restore it to the second server. 3. Implement Merge Replicaiton between the two. 4. Replicate only stored procedures and its execution to im...more >>

Hi all, I have problem when conducting the replication. Some tables in subscriber side contain default values and null values respectively. After replication, all these fields are blank. Is there any setting to keep the default and null values repectively after replication? Thanks a lot...more >>