I have a report that runs on a specific time. I save it into a windows file share so anybody who has access to that windows file sahre folder can view my report.
I wanted to have custom made log. Each time a report is executed, I wanted to insert a record on a specific table -- e.g Report file name, extension file, date of execution and even the parameters used by that report.
First off, are you aware of the execution log in the reportserver database?
select * FROM [ReportServer].[dbo].[ExecutionLog]
More info about this is found here: http://technet.microsoft.com/en-us/library/aa972247(SQL.80).aspx
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.
by Mark Wills
Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server... So if you are the accidental DBA, or, simp…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted? Many believe this is the case.
Let us try to examine for ourselves with an example.
To get started, use the following script, wh…