karthik M (7/30/2014)
I am not still clear.Once I create the subscription view, how should i access that view from the user database?
With a SELECT statement.
You can automate this through stored procedures or with SSIS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP