Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

need a suggestion on Exposing the Data to Customers Expand / Collapse
Posted Tuesday, January 22, 2013 11:56 PM


Group: General Forum Members
Last Login: Saturday, February 01, 2014 5:00 PM
Points: 193, Visits: 621
Hi All,
I joined a new team and need a suggestion on exposing data to downstream customers.
I have 5 SQL Instance on different Clusters which has 13 databases that are exposed to users. All databases are CDC Enabled and users have CDC_Admin access and they pull through CT Tables. My question here is

1) Will user's select statements have any negative effects while our CT Tables are getting populated with 2 records for every record in base table?

2) How else can I expose these data to users. I do not want them directly attaching my warehouse SQL Instances. Like if I can get few options I can think about the feasible ones for me.

Post #1410361
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse