You could edit the Stored Procs on the Subscriber to check for the correct conditions before procedding the data. Depending upon how many tables and how you identify the data...

SQLBits have just announced their next conference - London Excel 4th - 7th March 2015.

You need to join the two tables based on the ID column, then the WHERE clause that Koen posted will...

You've installed SQL Server with an option to cater for Replication but you haven't actually set up any Replication yet.

Once you create a Publication a Distribution database will be created...

There was an article about this some time ago - http://www.sqlservercentral.com/articles/T-SQL/95670/

Rechana Rajan (10/17/2014)

---

Thanks Gianluca & BrainDonor,

Its 'The wait operation timed out' error looged in our exception table and i believe its timeout experienced for customer when accessing the site.

had a...

A server-side profiler trace is quite light but it depends upon how much data you're trying to save from the trace. It has to write the results to a file...

Snargables (10/16/2014)

---

Will transactional or snapshot replication work accross different versions of sql server standard? I'm going t to set it up between a sql server 2012 instance and a sql...

Bill Dykstra (10/16/2014)

---

Thanks BrainDonor.

I have...

Have you looked at Replication?

We use it extensively here for precisely that purpose. Data is copied across regularly and the staging data can be read.

When you run the package locally you obviously have the required permissions to access the databases involved. When you run it from the server that you exported it to, the...

matthewlee887 (9/30/2014)

---

When copying 1.2 GB mdb from pc to network, it seems that the copy created in the network is corrupted although I'm not able to tell by looking at...

An excellent resource for date-related queries is Roby Page and Phil Factor's Date/Time workbench:

https://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-datetime-workbench/

You need to be patient when asking for assistance - a lot of people here have full-time jobs and answer when they are able.

Have a look at WITH NOCHECK, which...

With the number of features within SQL Server it is actually quite hard to decide what somebody with 5 years experience should know - its really down to want you...