DATRIPTION IN SQL SERVER STANDARD EDITION
Technical documentation of various approaches to implement data driven subscription in standard edition
WHITE PAPER - BY VIJAY MOORTHY
TABLE OF CONTENTS
Creating Data Driven subscription in SQL Server Standard Edition ............................................................................... 2
Audience Knowledge perquisite ................................................................................................................................ 2
Purpose ...................................................................................................................................................................... 2
BACKGROUND and Problem Statement .................................................................................................................... 2
Introduction to Data Driven Subscription .............................................................................................................. 2
PROBLEM STATEMENT .......................................................................................................................................... 2
Solutions .................................................................................................................................................................... 3
Approach 1: USING Simple SUbscription Solution and other report server sql management object ................... 3
Approach 2: Using Reporting service (ReportExecution2005) and .Net framework ............................................. 6
Solution Comparision ................................................................................................................................................ 9
Recommendation ...................................................................................................................................................... 9
@Copyright Author-Vijay Moorthy Page 1
T
’t
I
