Hi Experts -
I'm try to find how data is routed from DB server when exporting to local vs share path. Below is my scenario.
I execute BCP command...

I finally made it to work by using filters when defining table lists to be replicated.

Thanks for information.

I finally made it to work by using filters when defining table lists to be replicated.

Thanks for information.

Hi,

I need DELETE to be replicated only for current 3 yrs data. Replication should not happen when the nightly job DELETE data older than 3 yrs. So what i did...

Hi,

I'm looking for similar process but i DO NOT want to replication the delete from nightly job in source table. I have nightly job that purge records in few source...

i couldn't fight back to those who said the question is wrong Chris :blink:

Gopi

Here is the proof that i followed placing reference link without pretending as if mine.

http://www.sqlservercentral.com/questions/T-SQL/71798/

Thanks for remaining to place Reference. There is nothing to hide or pretend and i agree i followed some blog content and msdn. I know its best practice to put...

So far Jason is following me 😛

Hello,

"Data Integrity" can be enforced in sql server through

PRIMARY KEY Constraint

FOREIGN KEY Constraint

UNIQUE ConstraintCHECK Constraint

Default Definition

so on..

My point here is all about enforcing "Unique Constraint".

This can be done in several...

Using SQL Server 2008.

I mean to say we can't use CTE for my requirement since this is not gonna be single column traverse in tree heirarchy. Request to read...

I have been using CTE in many cases. But this is a special scenario where we can't use CTE. If you could provide then that will be more helpful.;-)

Hi Steve,

There can be multiple intermediate hierarchy. There can be n number of Region levels as below

C1-> R1->R2->R3->R4->B1

C2->R5->B2

Thanks

Gopi

Hi,

Thanks for your comment.

I think my question is not clear. Branch2 ProfileID is 7. If You look at profile table @ ProfileID 7, Grp2_inherited = 1. It means all values...