I have a table being replicated with two columns named "effdate" and "termdate" which have a datatype which are smalldatetime. The value for "effdate" is 10/1/2002. The value for "termdate" is 12/31/2078. On my production server when I query this table it returns the values "2002-10-01 00:00...more >>

I disabled publishing on one of my SQL2K servers but the subscription at my home office did not go away. Does anyone know how can I get rid of this sub? Thanks, Joe...more >>

I have two SQL 2000 Standard servers. The servers have a frac T1 between them. Users from each side write to their respected databases. I've been trying to setup replication so that the datbases stay synced. I've set one as the distributer and published the database as merged. on the other...more >>

I am running Merge and Snapshot transaction on SQL2K w/ SP3A with separate Publisher/Distributor. My log file on the Published database will not truncate. I ran sp_repltrans and the results are below: xdesid xact_seqno ---------------------- ----------------------...more >>

I have Already converted my old Access db to SQL 2000, now that testing is complete I want Import my current data from the old Access db that the users have been working on the last two months, how can I do this...more >>

I want to automate the replication of dynamically created tables. I can CREATE the table and I can add the table to the group of tables that will be replicated (sp_addarticle), but I don't know how to run the SNAPSHOT agent automatically. Can someone please tell me how to run the SNAPSHOT age...more >>

Hi there, Every now and then I read about a setup of transactional replication AND logshipping. I wonder why you would want both? Any benefits I'm overlooking? I would think either option would so. Also, what would be the more advisable option to keep a warm standy backup, transactional replica...more >>

Hi, I am going to reinitialize the replication at the subscriber. Will this action lock the tables at the subscriber and how long will it take? Any adverse impact on the subscriber? Thanks....more >>

Dear All, What can I do if the message The subscription is marked inactive and must be dropped and re-created. is appeared? Thanks for your opinion....more >>

I'm trying to set up a warm standby between 2 Windows 2003 Web edition servers running MSDE across the web. The idea is to do a DB backup once a week , ftp the file to a backup FTP server, then ftp it up to the warm standby server and restore it. Then, each our do much the same with a log ba...more >>

hi, Servers Configs: Win2K with SP4, SQL Server 2K with SP3 I'm setting up replication b/w two servers, one is on my pvt. n/w while the other one is on internet. When I tried to configure Publishing, Subscribers and Distribution... I get Error 18483: Could not Connect to XXX Server because dis...more >>

Hello, Where can I find some documentation (examples) of Reporting Services? Thanks, Ruslan ...more >>

We have a database where consistency is a must, and we use referential constraints extensively. We are finding a lot of problems in setting up replication since we are replicating only a few tables, but all of them are related to other tables that are not being replicated. So far we have create...more >>

I have set up a transactional replication where I have 1 publisher and 2 subscribers. I have activated the subscription as being updatable. When I change a record (UPDATE) in subscriber A it replicates to the publisher with no problem. But when this update is sent to subscriber B it is being s...more >>

Hi, I use SQL Server 2000 SP3 and using Transaction Replication, My replication running well, but yesterday/suddenly I found error at Log Reader Agent History : "The process could not execute 'sp_replcmds'on 'XLINK-SQL' " is there any store procedure should I fix ? can any one help me wi...more >>

I want to drop a table from being replicated without breaking and restarting replication. The closest thing I could find in BOL is sp_droparticle. However, it still seems that you have to break replication to use this sp because it won't work if a subscription exists to it. Am I missing something...more >>

Log reader is running but is giving following error:"Error Attempt to retrieve row from page via RID failed because the requested RID has a higher number than the last RID on the page. Rid pageid is 0x1b and row numb is 0xfffff654. Page pointer =0x1a7ad800, pageno = 15072407, status = 0x10d...more >>

Hello, I've setup a database with merge replication. I have enabled Automatic Identity Range Handling on some tables with identity columns. When inserting a record on a table with range handling, I get an error saying the publisher has run out of identity values. Is there a job that needs to r...more >>

I am getting the following error message while attempting to create a Merge Publication for anonymous use. Error 2758: RAISERROR could not locate entry for error 21423 in sysmessages. Object 'myDB1' does not exist or is not a valid object for this operation. I do have a database named '...more >>

We've been having the problem that everytime the publisher server is shut down for maintenance, and it stays down for over 72 hours, then when it is turn on, the replication status changes to DEACTIVATED later to reinitialize. Reading Books Online, I found that I can avoid deactivation by NOT ...more >>

need to set up replication with a distributor - does anyone know a good article on how to do this ? when i publish the articles, how do I like the subscriber to the publisher when there is a distributor in the middle... do I point to the distributor ? ...more >>

I set up log shipping using the maintenance plan wizard. Everything seems to have setup properly. The transaction log backups work properly. The copying of the logs from Server A to Server B works properly, but it doesn't seem to load the transactions into the database on the secondary server. T...more >>

Hi, I have been looking for an explanaition on naming in the SQL servergroup. I connect to other SQL 2000 servers using the fully qualified domain name (fqdn) of the server. The servers are physically hosted at various plces over the world. No VPN exists. Our servers are named by color...more >>

Hi, I have two servers Server A : NT4 + SQL7 + SP3 for publication and distribution (snapshot and transactional replication) Server B : W2K + SQL2K + SP3 for subscription (pull subscription) Sometime, i found an error message from the distribution agents in the server A, it said << The s...more >>

Hi, We are using replication between sql server 2000 and sqlce. When we create a Publication and run the snapshop we get an error like below: The process could not bulk copy out of table 'filt5F602.....'. What may the problem be. Thanks for your help. ...more >>

We are currently accessing multiple remote servers via ODBC (TCP/IP across the internet). Is it true that both the password and the data are both traveling across the internet UNENCRYPTED? What are the alternatives? It has been suggested that we write a Web Service which the application woul...more >>