Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

MS SQL Server Reports

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
Benki Canoso
Asked:
Benki Canoso
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>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
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Thanks for the grade.  Good luck with your project.  -Jim
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now