DATA DRIVEN SUBSCRIPTION IN SQL SERVER STANDARD EDITION

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

---