?
Solved

SQL Server 2005 Report Server Database

Posted on 2010-08-24
6
Medium Priority
?
272 Views
Last Modified: 2012-05-10
Does SQL Server 2005 allow manual inserts into the reporting server database?  I would like to populate the necessary tables/columns in the reporting database and have reports scheduled and executed without going through reporting services.  
0
Comment
Question by:nitayalevette
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 12

Expert Comment

by:mcv22
ID: 33515172
The reporting services database schema isn't documented and frequently changes between versions. Having said that, you do have an option to programatically generate report definition files (refer to : http://msdn.microsoft.com/en-us/library/ms170667%28v=SQL.90%29.aspx).
0
 

Author Comment

by:nitayalevette
ID: 33515825
does this include scheduling?  Are RDL's necessary in order to schdule a report?
0
 
LVL 12

Accepted Solution

by:
mcv22 earned 1000 total points
ID: 33516030
You can use reporting services scripting language to create an rss file:

http://odetocode.com/articles/114.aspx

Another way to do it would be through SQL management studio. Create a subscription all the way until the last step. Then click on script to file. Refer to http://msdn.microsoft.com/en-us/library/ms152908%28v=SQL.90%29.aspx on how to run rss files.
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 9

Expert Comment

by:sureshbabukrish
ID: 33519209
i think yes you can update
0
 

Author Comment

by:nitayalevette
ID: 33520873
I'm looking for an automated way to create the reports.  I think I want to create the RDL, and then insert the schedule with a script or code.  Which tables in the reporting database do I have to update to have an automated report delivered?
0
 
LVL 12

Assisted Solution

by:mcv22
mcv22 earned 1000 total points
ID: 33523652
For the schedules, following are some of the tables that will need modifications for sure (there might be more): ActiveSubscription, Notifications, ReportSchedule, Schedule, Subscriptions. You will also need to set up a job and modify the corresponding columns in these tables to update with the job name generated.

I would advise creating a test subscription and have SQL profiler running the background to make sure that you don't miss anything.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

765 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