I have transactional replication setup on a pair of SQL 2000 machines. The issue i have is, one of the tables has over 285 columns. I understand that SQL SERVER 2000 limits columns to 255. Is it possible to filter out unneccessary columns before i add the article to the Publication? I found out ...more >>

SQL Server Enterprise manager showing Distribution database as SUSPECT and in result replication monitor do not show any information about replication agent(Merge agent etc). I detach database and try to re attach but system showing that database cant be attached as "log scan" to those file is ...more >>

We're planning on upgrading our SQL Server 2000 publisher to 2005. It has several MSDE pull subscriptions. I am trying to get Northwind as a Publisher to one MSDE subscriber but I've been having lots of difficulty. I have created the publication and the pull subscription, but the subscriber...more >>

Running SQL 2k SP3a & Win 2k Today, all of a sudden, my SQL server started going up and down. In the System Event Log, I received the error Event Type: Error Event Source: Service Control Manager Event Category: None Event ID: 7031 Date: 12/21/2005 Time: 3:37:50 PM User: N/A Compu...more >>

The following sp runs about 3 in on a 2005 ssds server and it takes a few seconds on a much slower machine running sql 2000.... I am trying to move all our replication to the new environments and setting everything up except the articles manually. Is this the best way to do it? exec sp_ad...more >>

I would like to replicate a large database to a reporting server on the same network. I have very good bandwidth between the two servers The DB in questio is ~200GB and has a transaction rate of ~3000 per minute. There are 10 tables that are > 10 GB's. Does anyone have any advice for me? o...more >>

I have the following error on Publisher, and i do not know why: Syntax Error or access Violation (source: SERVER_NAME (ODBC); Error number: 37000) When i run the command (ins, upd ...) in suscriber, it goes very well, but not in replication agent, which stops immediately. Thank you very ...more >>

Hi there Setup: SQL 2000, Transaction replication, continuous distribution agent I have a single one-way publisher-subscriber setup. Numerous update jobs to several tables happen at the publisher, kicked off from DOS batch files. Batch file export jobs run against the subscriber. The export...more >>

Hello, Can replication be set up between two servers in different domains? What if they are in the same forest? Regards, Randy. ...more >>

I used the add_relpcolumn to add column in the published table but not knowing that the subscriber database does not have the table. I found the error on the distribution agent about 'Not able to alter the table because the table doesn't exist', which explained what happened. As a result, it...more >>

I’m setting up transactional replication, the snapshot generates fine, but I get error code 1038 “Cannot use empty object or column names. Use a single space if necessary.” when the distribution agent does the push replication and reaches a particular SP. Something to note is that ta...more >>

HI, I try to use the FTP protocol to transfert the snapshot file from the Distributers to the subcribers What I did is that I right click on the subcription on the subcribers Laptop I choose the tab Snapshot File location Instead of using Get the snapshot file from the Publisher normal sna...more >>

Here's what I'm trying to do. I have two servers. I've set them up using Microsoft's built in load balancing. I've installed WSUS, using MS SQL Server 2000 for Workgroups on each server. Now all I need to do is set up merge replication of the databases so that they stay in synch with one an...more >>

Hi, I would like to know what can I do to with a log file that is growing very fast. Every 3 days I have to detach the database,delete the log file and attach the database with out log file. During the process a new log file of 504 kb is created. Each day the log file is growing by 1.5 gi...more >>

Hi, I have noticed that distribution database which is used for transactional replicatiton became large. Can I shrink the database? Transaction log is the same size as the data file. I run dbcc loginfo(distribution), status field shows that there are a lot of unused parts. Can I shrink transa...more >>

Hi, I am trying to set up the following Scenario. Web Server in SQL Server 2000 Enterprise and Notebooks Running on MSDE people can update the application In Web Server As well the Disconnected Notebook Application . and on regular intervels these dbs should be in Sync. I tried MSDE as a Su...more >>

Hi, I have an ERP system running on SQL server 2000. How do i actually go abt doing performance tuning as a DBA ? i can check the no of ppl using the ERP and their activities. but come to slow performance , how do i actually go abt doing performance tuning ? for example , for this f...more >>

Hey All, Is there a way thru which I can reinitialize a subscription using a batch/ script file. Or force the generation of a snapshot and force apply the snapshot using a batch/ script file. Thanks a lot for your help. Jatin *** Sent via Developersdex http://www.developersdex.com ***...more >>

Can anyone tell me what could be causing the following deadlock issues? I have done a SQL Profiler trace which isn't picking up the Deadlock. The subscription type is pull and there are more than 12 merge agents on the Publisher The process could not enumerate changes at the 'Publisher'. P...more >>

Hi All, I have set up MERGE Replication with NOSYNC option and 14 days subscription retention period. My both the servers are in sync with each other since when I started replication a month back. But I find there are thousands of records in MSmerge_contents, MSmerge_tombstone, MSmerge_g...more >>

Is there a list anywhere of the system stored procedures that are used strictly in replication? Thanks. David ...more >>

We are testing SQL 2K Merge replication on a server and we need to restore from a backup that was created right after the publication was setup. Do we need to re-run the snapshot before we can re-create a subscriber? Thanks. David ...more >>

New to merge replication - sql 2000 I simply wish to add a table to the publisher database and this table will never be replicated. Is there anything I need to do to exclude it? Thanks, Craig ...more >>

Hello there I some questions: 1. Iw'd like to run some store procedures before i'm starging the replication every day. Dose it enouth to add the task before the replication task? 2. If the replication faild i would like to make sure that none of the changes will be made. 3. IF an error occu...more >>

Hello there After i've created my replication I aslo create script for recreating it again. However, After i create the replication again the names of my Jobs are being changed. Is there a way to create constant name to the replication jobs? ...more >>

Hello where After I finished my replication I have a problem: After i set the publisher I can't change or drop the replicated table and I can't detach the database. So far for changing or droping replicated tables i: 1. drop the publision 2. do all the changes on the schema. 3. Create t...more >>

Hello there I have many tables on my database (Approx 500) Many of them have identity column and none of them are set for Not for replication Is there a way to change it by code automaticly? ...more >>

Hello, We just decided here to stop using SQL Replication and move to something more low-level for data redundancy (RAID replication) But after using sp_removedbreplication on each replicated databases on the server, I noticed that one of these databases kept its syncobj_0X views, even if r...more >>

Hi All, I have a replication schema already created, but when I initialise my push subscription, insert triggers on the replicated tables in the subscriber are not firing. Can this be done? Anyone know of a workaround? Thanks, Mark ...more >>

Hi all, I have my replication schema already created and on the subscriber tables i have various insert triggers. However when I initialise a new push subscription from the publisher, the triggers are not firing as I hoped. Can anyone offer any advice on this? Thanks, Mark ...more >>

Hi, I Have to install a hot fix for Sql server 2000 I need to instal this Hot fix by programmation from a vb.net application that I Made What parameter or switch that i need to pass when I Call the install.exe hot fix the problem is taht during installation, the installation setup ...more >>

What are these? The have a naming convention, the start with something like ael_0DE5BDEB330C4C0BB08D0DFAB7434EFC and go to all 'z's. I thought maybe sp_removedreplication may clear them up, but nope. they are becoming anoying, there are sooo many of them. How do I/ should I get rid of ...more >>

In the replication wizard, the first menu "SELECT DISTRIBUTOR", have two options a) Make the "Myserver" its own distribuitor, SQl Server will create a distribuiton database server and log. b) Use the following Server, ( The selected server must already be configured as Distribuitor). Wh...more >>

Internet merge replication. Need to detach to move to a new box. Deleted all the publication, now when I try to disable it as the publisher. I tried to run sp_removedbreplication 'db_name' and get the same message. Any thoughts? Thanks...more >>

My topology: On the national Server: SQL 2005 Enterprise On the mobile clients: SQL 2005 Workgroup. The Scenario: 2 mobile subscriber S1 and S2 to the same simple merge publication P1 on server N Day 1, S1 and S2 both synch up with N and both go off to d...more >>

Hello... Some background: We have merge replication set up between SQL 2000 and mobile devices running SQL Mobile. Each of our customers has a unique customer id and currently we have a separate publication for each one...that has a static filter such as "WHERE CustomerID = 12345". And o...more >>

I have two orphan subscriptions on a SQL 2000 server. I need to drop both of them. Can anyone help me out with the syntax to do that? I have been trying to use sp_dropsubcriber and sp_dropsubscription, but I can't seem to figure them out (of course I am assuming that one of these is the one...more >>

I can't get an anynonmous pull subscription to work. Server is Windows 2000 with SQL Server 2000, client is XP Pro with MSDE 2000. Setup replication on the server using the wizard: Snapshot folder in default location merge one database don't select any subscribers (my client isn't listed) ...more >>

Sorry, me again. The snapshot agent problem has now caused the merge agents to fail with the message that the snapshots files are now obselete and i need to create a new snapshot, but i cant because of the publisher wont generate a new snapshot (see prev posts) Help! Thanks Nick...more >>

Hey All, I've been successful in running the distrubtion agent and starting the synchronization process thru the command line. However, when I start the process, a dos pop-up appears and provides the status of the operation (at the end a Ctrl+C closes the pop up). Is there a way I can suppr...more >>