CODEWITHSUNDEEP
sqlsql-server
schar
schar

Reputation: 2658

SQL Server replication question

I had inherited this SQL Server where we put data in a table (Call TableA) on a database (DB-A). I can see the tableA in another database on the same server ( DB-B) gets the same data right away.

Any ideas how this is implemented? I am trying to see the trace but so far no luck. Any one has an idea?

At this stage I am not sure if its replication. This is a guess

Upvotes: 0

Views: 307

Answers (3)

Dave Markle
Dave Markle

Reputation: 97691

This is most likely happening by use of either a synonym or cross-database view. Check to see if the "table" on the other database really is a table. If it IS a table, then they've set up transactional replication between the two databases.

select type_desc from sys.objects where name = 'name_on_database_b'

Upvotes: 1

Randy Minder
Randy Minder

Reputation: 48402

It could be replication or it could be a trigger on the source table that is moving the data over.

Upvotes: 1

Jeremy
Jeremy

Reputation: 4838

Perhaps it is transactional replication? You should be able to go to the replication are and see if there are subscribers or publishers. Either that or you have linked servers, and triggers are copying the data.

Upvotes: 1

Related Questions