Hi, I am moving MS Access 2000 databases to SQL Server 2000 and am really struggling with setting up the replication, does anyone have URL's to tutorials or whitepapers on the subject. book recommendations that cover setting up replication would be good too. Thanks. -- Kevin Marsha...more >>

Hi . I',m new in a merge replication . How can I delete the subscriptions from a merge subscriptions . I heard exists a script can do it . Anyone knows it ??? Thanks a lot . ...more >>

when i add a new server in [new sql server registration] wizard, it sho a error message "login failure for user 'sa'.Reason: not associate with a trusted sql server connection." I had entered the correct logi name and password ab --------------------------------------------------------------...more >>

Hi All, I setup replication on a SQL 2k server, and it never worked properly. I couldn't get it to sync. I called Microsoft and they were not able to help. I tried to disable replication but I recieved the following error: Error 8646: The index entry for row id was not found in ind...more >>

Hi, I would like to know if anyone of u has any idea of replicating a SQL Server Database to a heterogeneous data source (Oracle / Access) or vice versa. If so please explain me on how to do so? Thanks in advance for your valuable support :-). Regards Prabhu Ram Prasath. ...more >>

I have a simple transactional replication test bed set up using SQL Server 2000 and I want to add a column to a table that islocated on the Publisher. After looking thru BOL, I found the "Filter Columns" tab on the Publication Properties dialog box and was finally able to add a new column into th...more >>

Hi: I created a DTS package that imports the Master Database from one SQL server to another for emergency's and it works fine except the passwords don't seem to come over. Is that a limitation or have I not configured the package correctly?...more >>

Hi Is there a stored procedure that can be used (or a select statement) that can determine if a SQL database has been published? Many thanks Ross ...more >>

I am using SQL Server 2000 to replicate data to a remote MSDE. I am using a pull subscription on my MSDE. I need to be able to programmatically stop the pull subscription and then programmatically restart it. I am currently trying to use stored procedures. I do not know how to stop the pull s...more >>

Hello, We have a transactional replication with on the publisher side a table = with 5.000.000 records. This table is replicated to a subscriber with the option filter rows = with the following filter: SELECT <published_columns> FROM <<TABLE>> WHERE=20 (DocDate >=3D DATEADD([YEAR], -1, GET...more >>

Hello, I need to keep sync between online transaction database and report database. Unfortunately the publisher database don't have primary key. Could you provide some info regarding 3rd party tools? Thanks...more >>

Does replication require that an existing GUID column in a table to be replicated be an identity? Thanks, Todd...more >>

Is there a way to programmatically copy a record to another server/database and keep the same guid value that is added for replication? Put another way... replication adds its guid field and I need to copy the records exactly as they are in the source database to another server/database. ...more >>

I trying to play and learn about replication, however I have hit a snag that I cannot seem to get around. I have created a simple DB with 1 table and a couple of fields for playing purposes. Box 1 is Windows 2k Adv Server running SQL 2000 SP3 Box 2 is WinXP Pro, Running MSDE with SP3. ...more >>

Hi, I have a problem with creating Differential File/FileGroup Backup. I use this T-SQL statement: BACKUP DATABASE MyDB FILEGROUP=3D'MyFG' to MyDevice WITH DIFFERENTIAL It creates the backup but when I look MyDevice's properties in = Enterprise Manager, my backup's type is Complete Databa...more >>

Hello I am having problems setting up transactional replication and have a couple of questions. I have a publisher, separate distributor and two subscribers (all SQL 2000) I create the publication OK (which includes tables, views and stored procedures), then a subscription which I set to every ...more >>

Dir All I have a question: I do not know dimension of transaction replication: 2 dimension between publisher and subcriber or 1 dimension up/down from publisher to subcriber. What dimension of transaction replication Thanks a lot for hel Best Regards TN...more >>

I have a transactional replication (SQL2K) and a push subscription to the subscriber. I have an update trigger on the subscriber which insert into another table changes that occured on that table. Why is it that when an update occured on the publisher and replicated the changes to the su...more >>

Lately we've been experiencing this error on one of our servers using replication. Error: 14151, Severity : 18, State: 1 Replication-Replication transaction-Log Reader Subsystem: agent Testserver1 failed. The process could not execute 'sp_replcmds' on 'Testserver1'. I've been restarting...more >>

I've enabled snapshot replication and now SQL Server is giving me an error when I update certain records: "Length of ntext to be replicated exceeds configured maximum (65536)". Indeed the records that give this error contain large ntext columns. How can I change the configured maximum ...more >>

Anyone know "sp_MSins_Response"? I have transactional replication in place(Central publisher model). the distribution agent is failing with the following error message: Could not find stored procedure 'sp_MSins_Response'. The step failed. I had a look in the distribution DB, SP is n...more >>

I have 2 sites. When the leased line is maintained 1x per month the line is unavailable temporarily. HOwever sql server replicaiton crashes. how can i detect the link and pause until the server is available again thanks in advance...more >>

hii,, i have this database that was part of replication , then after reomving the replication , which was unfortunatly not correctly reomved , still i noticed that the fields of replication in the database so am not able to modify the database insert , update , delete each time give me erro...more >>

Dear experts, I've a system which was run by sql servers (one central server with 20+ distributed servers). The replications are either in push, pull or merge mode. I found the perfermance was degraded a lot when I added the disbuted sql servers, with a lot of waits or even deadlocks). W...more >>

1. how are transported snapshot from publisher to subscriber ??? ... i know that first can go via ftp etc... but what about next snapshots ?? 2. can i change structure of publicated table ??? for instance i want add a column , how to do it whitout cancel the publicution ????? ...more >>

I am trying to set up merge replication between two SQL 2000 servers connected via a VPN. Both servers are running XP professional. I set up using SQL authintication whenever possible with an account that has database owner rights I set up the snapshot location to be in a directory that is under...more >>

I've just upgraded two database servers from SQL 7 to SQL 2000. Everything was working just fine. I wanted to try replication between these two servers but as I was trying to create a publication on the publisher server, I got the following error message: "the distributor is not available" Error...more >>

Dears,[ Is it possible to make replication of objects. For example: I have two servers (S1 and S2). Evertime I change a procedure on S1 I want to alter the same procedure on S2. I think I have to make a synchronization between the master databases of the servers, but I don´t know if i...more >>

Hi All; I have a merge publication with dynamic filter enabled . I have used HOST_NAME() function to filter record.. When i create a PUSH subscription the not work properly .. I mean it send nothing to Subscriber.. But when i create PULL subscription it work properly.. I have run Merge agen...more >>

Hi - I'm trying to figure out how to do this? I've got the Publication set up on the SQL Server - (i've done this before, so, I know it's right) But, I don't know what to do in my Client MS Access application to get it to bring down/subscribe, use local copy, and replicate data back up to se...more >>

Does anyone know how to automatically restore a database and datbase log file that has been backup up to disk? I have a maintenance plan that backs up my DB to a file. Now I would like to have a process that restores this file automatically. Thanks for any info....more >>

I have already deleted the publication that had a push subscription. I still have the subscription there. How can I get rid of it? Thanks...more >>

Hello All I have SQL Server 2000 server where the database is replicated across 20 laptops which use MSDE. They are all mobile users and connect at various time intervals to Sync with the Main Server. Of all the tables there is one table which is not replicated. When I am adding extra Column...more >>

Hello, I have a question about the history in replication monitor/publisher/<server>/<publication> of SQL 2000 Enterprise Manager. There is a filter "latest 100 sessions" set. But I can see only the latest session(s). What am I doing wrong? Michael...more >>

Is it possible to replicate data from one table to another if the subscriber does not have the same schema as the publisher? At the central office we have a common product table that contains the products and their pricing. Each store has a similiar table schema with one additional column tha...more >>

One of the table in a multi-article publication is out of sync by one record. To fix the problem, the only way I know is very cumbersome which is to drop the subscription, fix the problem then create the subscription again. How can I disable the replication for that particular article(t...more >>

I am trying to setup two way replication for tables which contain ntext fields. However, it will change the value of the text column to "null". What is the work around to insert a record on the subscriber site which contains data in the ntext column?...more >>

Hi, As the topic says I seem to have come across a problem when creating snapshot for tables that have a space between words. Heres an exact error output for 1 table Initializing Connecting to Publisher 'CO3057376-A' Locking published tables while generating the snapshot Preparing table...more >>

Hi I wish to replicate small amounts of data from our local SQL server 2K (Standard Edition) to our remotely hosted webserver which is also SQL Server 2k. As security and client confidentiality very important to us is it possible to do this using encryption? Our web host will charge us a...more >>

To all, I need to modify insert / update/ delete stored procedures that transactional replication generates through (as far as I can tell) the following procs: sp_scriptinsproc sp_scriptdelproc sp_scriptupdproc Basically, I need to add a function call to the end of procedures generated....more >>

Hi Guys, How can I add a dynamic horizontally filtered table to a merge publication without having to reinitialize current subscribers? The new table must be join filterd with a currently published filtered table. thanks in advance. ...more >>

Hello, A server has started to fail when creating publication, in my case snapshot The error is as follows "SQL Server Enterprise Manager could not create publication 'NewPub' from database 'NewDatabase'. Error 515: Cannot insert the value NULL into column 'step_name', tabla 'msdb.dbo.sy...more >>

I'm trying to delete a subscription for a publisher and after choosing delete the application hangs. Running SQL 2000 SP2. Help? ...more >>

Can I write a program that can read the snapshot file's content and write them into a file. Maybe SQL does not have this kind of function. -- ×£ ¹¤×÷˳Àû! ÂÞ½¡ (+86)021-62786210-811 luojian@corswork.com ÉϺ£ÎÖ¿ËÈí¼þÓÐÏÞ¹«Ë¾(www.corswork.com) ...more >>

Hi all, Is there anyway to retrieve/revive the subscriptions deleted by the distribution cleanup agent...??? ...more >>

I'm using transactional replication to replicate a database for reporting. Now I need to replicate that replicated (reporting) database to a heterogeneous subscriber (Informix), but when I go to set up the articles, all the tables are locked. Also, I can't go from the published db to Informix,...more >>

I am trying to find a copy of the report sever. I am currently running server 2000 and want to try out the reporting interface....more >>

I am running Win 2k & SQL 2k on all servers. I am doing merge replication between several servers, Server1 is where the publication was created and ServerXX is where the subscriptions are created. Everyday, on one, if not several servers, the merge subscription(s) report 'Never Started'....more >>

Hi Guys, I am very curious to learn and set up replication. I have a desktop. Can I implement some kind of replication on desktop may be from one database to another. thanks a lot. Note: I have studied 3 type of replcation and some other theoritical stuff. ...more >>

Hello, I recently created several publications(for snapshot replication) along with subscriptions. The articles to be published were all views(over a hundred of them). I had to delete the publications/subscriptions and now I notice that there are hundreds of syncobj_* views(in place of...more >>

We have SQL2000, sp3A. Tranasaction Repl One of the tables, ORDERLINE, is fairly big (23M rows). During the initial snap shot phase, the snapshot agent terminates with a Time Out error (after 10 mins) at the 'Preparing Table ORDERLINE for merge' step. I am using std wizard to create the publi...more >>

Hi All; I want to fill a combo box with list of registered subscriber.. i have wrtten the following code in Visual Basic 6 Dim objServer As SQLDMO.SQLServer Dim allSubscriber as SQLDMO.RegisteredSubscribers objServer.Connect "Matrix","SA","" Set allSubscriber = objServer.Replication.Publ...more >>

Server A is configured as the Distributor and Publisher for this replication environment. Three publications are configured (one transactional and two merge) to replicate with Servers C-I. The transactional publication is set for all tables/views/stored procedures except for 3 tables of ...more >>

We have merge replication set up between 2 of our local servers. Both are MSSQL 2k, SP3a. As part of our database, we have tables for Software and SoftwareMedia where the Software may have many SoftwareMedia (e.g. disks 1 - 4). Foreign keys are defined on the 2 tables such that the SoftwareMed...more >>

I am doing some research on transactional replication and it seems to me that many articles stresses on how a reliable connection is necessary for transactional replication. I do not find the same issue to be emphasized for merge replication. Why is connectivity more important for transa...more >>

SQL2000 publishe SQL2000 and SQL7 subscriber The insert trigger on one of my merge replications mysteriously changed from sp_insxxxxxxxxxxx to ap_insxxxxxxxxxxxxxxx I then started receiving conflicts from the subscribers saying a record could not be inserted because the trigger ap_insxxxxxxxx ...more >>

Hello All - I need the fastest method to replicate data in a central database to subscribers. I have a beta version of the app using merge replication. With just 2 or 3 users, it takes approx. 3 or 4 seconds for the subscribers to be updated. This is a Wall St. app and time is critical. ...more >>