Solved

MS SQL Server Reports

Posted on 2014-12-02
2
269 Views
Last Modified: 2014-12-03
How can you determine if there are reports for a particular database in MS SQL Server? Can you see what reports have been created for a particular database in SQL Server?
How are SQL Server reports normally created so that an end user has access to them?
0
Comment
Question by:Benki Canoso
[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
  • 2
2 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 40477727
>How can you determine if there are reports for a particular database in MS SQL Server?
You can't.  There is no T-SQL that returns a set to the effect of 'Give me every external file (SSRS .rdl, SSIS .dtsx, etc.) that references this database.', so your options are either to go on a wild goose chase to find these files, or shut the database logins down and see what breaks / who complains.

A way I've tracked this in the past is to write a Stored Procedure as the main data source for a report, and in each sp (which I prefix ssrs_) do an INSERT into a homemade logging table I created.  That way all activity is in a table.

I believe with SSRS 2012 there are tables to monitor report usage.

>How are SQL Server reports normally created so that an end user has access to them?
SSRS reports are created by developers using Visual Studio / SQL Server Data Tools, depending on the version, and then deployed to an SSRS server for users.
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 40478350
Thanks for the grade.  Good luck with your project.  -Jim
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

738 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