This article presents a pair of queries and reports that reads the ReportServer.dbo.ExecutionLog table to list all SSRS reports that were executed or not-executed in the past 30 days, how many times they were executed, and who executed them.
2020-01-17 (first published: 2017-04-25)
8,542 reads
This article demonstrates a method of generating SSRS report documentation by using an SSRS report that queries the ReportServer.dbo.Catalog table.
2017-04-11
9,584 reads
I don't know if you can detach system databases, but you can try this:1. Shut down the SQL services2. Copy the system ldf and mdf files3. Install SQL Server to same version and service pack level4. Stop SQL server5. Rename new system databases6. Put original system ldf and mdf in place of new files7. Start up SQL.I […]
2005-01-17
Thank all of you for your replies. I ended up going the dynamic SQL route. The query was originally well over 8000 characters but was a UNION query. I busted up the query and it worked fine.Thanks again...
2005-01-11
I swear that I picked the answer without the 'false' parameter; but the answer page is telling me that I picked it. Has anyone else experienced this behavior? .... or has the DBA stress finally overcome me?
2005-01-05
I am very aware of the need, not just in Srilnka, but in all the countries that were hit. I must question your legitimacy, if you are true, then you have my prayers. Anyone who wishes to help would do better to donate to the local, national Red Cross (http://www.redcross.org/), or whatever relief organization exists […]
2004-12-29
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
By DataOnWheels
DIVERSIFY! We devote a lot of time to mastering the technology that we are...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers