I've inherited a project which has numerous fields that have extra spaces in them -- this is causing a problem with data Inserts, Edits, and Deletions in my .ASP Website. I'm importing data tables from ACCESS 2003 into SQL Server 2005, and I need to know if there's a way that I can Right Tr...more >>

I'm at a place where they are (SS 2000 SP4) replicating from one drive to a different drive. But, come to find out, that really the way the SAN is laid out, these drives could very easily all share the same spindles/heads. Now that's madness isn't it? Even with cache, isn't this asking fo...more >>

Hi, I would like to know if 2 SQL servers residing in 2 different networks replicate? If yes, Pls provide information for the same. Vibhu....more >>

I have a table in a merge publication with 11 subscrber. I need to modify the primary key of the table. Now the table have a primary key of one column. I need a primary key of two column. How can I do ? Thanks ...more >>

Here's out situation: We have a database with about 50 million records, full text indexing is enabled for one column. About 200,000 new records are added every day replacing an equal number of records that expire. All updates to the database will be directed to the master server database, so ...more >>

Hi, I have a replication table. However one of the field's datatype needs to be changed. The system does not allow me to do so. However I must change the field. How can I do so? Thanks...more >>

Does anybody know the best way to query the system tables to count reinitializations that have occurred? We are beginning to have some performance issues with our replication setup, and we are trying to find some trends (we have been archiving off the data from the system tables, so we have...more >>

We currently run one SQL Server. We would like to add a second for redundancy. This server would be located at a separate office connected by a Frame Relay, so it would be on a different subnet. Can someone suggest the best way to accomplish this? Thanks...more >>

In the Books online it says : Replication is a set of technologies that allows you to keep copies of the same data on multiple sites... Could someone give me an answer on what is the 'set of technology' that keeps the transactional replication running. Does it use DTS packages (or Integrated ...more >>

We have a merge replication system with: 1 (2K5) Publisher 100+ Pull (2K) subscribers (U.S. & Canada) 89 tables replicated LAN (VPN) network Our "logical" topology is really a multi publisher to single subscriber, but since that's administratively not feasible, we reverse it. Each time a n...more >>

Hi, I have a transactional replication with 2 subscribers and I want to filter the data to one of the subscribers but I cannot do it with the row filtering options on replication because it doesn't allow join filters which are only allowed on merge replications so how can I do that with tra...more >>

Hi are running Sageline 200 with sql 2005 backend. On out system, we have two companies,each in a seperate database, both with identical tables and schemas. I want to replicate some of these tables inro a single table on a remote server i.e. db1.dbo.stock and db2.dbo.stock onto a remote...more >>

I'll be doing an in-place upgrade of a couple SQL 2k boxes in a couple of days. One has a publication/subscription that the other box pulls. Should I do my SQL 2k5 upgrades in any particular order? For example, do the subscriber box first then the publisher, or vice versa? Do I need to dro...more >>

Hi, I have a sql server 2000 SP4 publisher and a sql server MSDE SP4 subscriber. After applying the initial snaphot I can see the inserted record information remains in the msmerge_contents table. Is this normal behaviour? Is there a way to prevent this. Our database is approximately 800MB a...more >>

I deleted about 3 million rows out of a table that is being replicated. So now, it is sitting replicating those 3 millison deletes to the 2 subscribers. What can I do to get it to stop replicating all of those deletes and start replicating the actual changes that have occured over the past two d...more >>

We have a CE .NET application that uses a local SQLCE database. Tee local database replicates to Merge replicated db. The Publication is set to expire every 14 days. If the CE device tries to replicate after the 14 days do we need to re-initialze the local database? Or will replicate handle...more >>

Hi, I'm getting the error: Error 14294: Supply either @job_id or @job_name to identify the job. Any idea to solve this problem. Thanks, Serge ...more >>

I am using SQL 2005 as pub and SQL EXPRESS as sub with Merge replication. Got the following error message The schema script 'CD_InTransit_v_153.sch' could not be propagated to the subscriber. Error Detail: The schema script 'CD_InTransit_v_153.sch' could not be propagated to the subscribe...more >>

You have to be extremely careful with the DDL scripts that you are executing if you are propagating schema changes through the merge engine. The gory details are all wrapped up out here: http://www.mssqlserver.com/replication/alert_merge_ddl.asp -- Mike - mhotek@mssqlserver.com MHS Ente...more >>