Solved

Sql Server 2005, Reporting Services, Data Driven Subscriptions

Posted on 2007-03-17
7
391 Views
Last Modified: 2012-06-27
Do you need to have enterprise edition of sql server 2005 in order to generate data driven subscriptions.  Or does anyone have a work around using standard edition that will allow queries returning 0 records to not email a 0 record report.
0
Comment
Question by:Fraser_Admin
  • 3
  • 2
  • 2
7 Comments
 
LVL 21

Expert Comment

by:Yurich
ID: 18744725
It should be fine with a standard edition:
http://msdn2.microsoft.com/en-us/library/aa179341(SQL.80).aspx

and here is a tutorial:
http://msdn2.microsoft.com/en-us/library/ms169673.aspx

Cheers,
Yurich
0
 

Author Comment

by:Fraser_Admin
ID: 18744981
why do i not see the option to create a data driven subscription?  what do I need to setup in order to have this option?
0
 

Author Comment

by:Fraser_Admin
ID: 18744994
This is a quote from the site you just sent me.....Doesn't look like I'm able to do this???

Standard Edition
Standard Edition is designed for a production server in a single-computer configuration, which centralizes server-side report processing, storage, and tools. Choose Standard Edition if you do not need to support a large number of users, and do not need to support the dynamic distribution of reports to many users. The following features are not part of the Standard Edition:

Report Server Web farm deployment
Security extensions, including support for custom or forms-based authentication
Data-driven subscriptions
Support for more than 2 processors
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 21

Accepted Solution

by:
Yurich earned 500 total points
ID: 18745374
You're right... that's what it meant to be, you must have an Enterprise edition
0
 

Expert Comment

by:pumaken68
ID: 18747483
I'm facing the same issue. I want to preload the cache in RS 2005(http://msdn2.microsoft.com/en-us/library/ms155876.aspx), which requires data-driven subscription but that's only available to SQL server 2005 enterprise edition. Does anyone know a walk around solution to this?

I found an article: http://www.codeproject.com/database/DataDrivenSubscriptions.asp but didn't quite get it because it's for RS 2000. Let me know if you get it working.
0
 

Expert Comment

by:pumaken68
ID: 18747747
Anyone who provides a solution for this question could get my 500 points as well at
http://www.experts-exchange.com/Database/Reporting_/Q_22457812.html
0
 

Author Comment

by:Fraser_Admin
ID: 18770670
I just ended up creating an sql server job that executes a stored procedure which creates an html page with the information and then emails it.  I just formatted it to be like a report.  Then inside the sp i can say if there isn't any records don't email.  Don't know if this help you.  It got me by for now.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
2 comma seperated list - SQL Server 12 38
Impove long SQL Stored Procedure Performance 14 69
passing parameter in sql procedure 9 56
Unable to save view in SSMS 21 59
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now