I could easily set up a job to run every 15 minutes or so. I was more curious to see if there are any known workarounds since we aren't concerned...

I suppose I'm trying to get too granular which is leading to more work than necessary. My hope was that grant alter could be broken down into more specific permissions...

Thanks for all of the information. It was very helpful because some things I read swear by adding an identity column for the primary key regardless of what type of...

Thanks pietlinden!

That's why I posted it under the Programming --> General category. The Programming category has subcategories such as PowerShell and testing methodologies so I did't think it was too far...

Thanks for the tip ZZartin. That fixed my problem. I didn't mention that each Excel file opened will run its own macro which leads me to my next issue. If...

I'm getting back to this topic so I have a couple questions. The goal is to have only one subscription that can fire every report. Currently I see two options:

...

Thanks for the information. It sounds like groups are the way to go even if at the time it only ends up being one person.

Steve - Thanks for the reply. There is a ton of helpful information in those search results. I should be able to piece enough together to make it work. Can...

SQL Server won't be doing the decompressing. I'm trying to use a third party utility that needs the backups to be decompressed.

I finally figured out what the issue was. I found that in the rsreportserver.config file this line existed

<Extension Name="ATOM" Type="Microsoft.ReportingServices.Rendering.DataRenderer.AtomDataReport,Microsoft.ReportingServices.DataRendering" Visible="False"/>

I had to update it to

            
June 20, 2019 at 5:34 pm
            
#3655868

            
            
                                                
        

There will some data manipulation to create matrices, charts, etc. From what I've read this can act as a source in Excel. The SSRS output will mirror the Excel version.

So in my hypothetical scenario, is my only option to find data changes to load the file and compare it to the previous day's table using the ID for all...

I called it a daily file in my hypothetical scenario of one that has the same structure of the tables. Sorry if that was not clear or got lost in...

I understand the concept but not how it applies to the situation I'm working with. Suppose today I create a new target table with the VersionCol field you explained above...