This line looks a bit odd to me too:
SET @TABLE_NAME = (SELECT...

I am slightly confused.
I took the code, copy-pasted it into SSMS 2016, connected to a SQL 2016 SP1 instance and ran it.  I got a different answer than the...

As a thought, does this query give you any results:
SELECT *
FROM tblA
WHERE tblA.id NOT IN (SELECT id
     FROM tblB)

July 12, 2017 at 4:03 pm

#1950657

May actually have a solution for you:
https://support.microsoft.com/en-us/help/3053960/fix-a-system-assertion-in-longrec.inl-1318-occurs-when-you-rebuild-or

I see you posted this in the SQL 2016 section and the above article applies to SQL 2012.  I'm guessing...

The other thing you can do is go into the SSRS web portal, navigate to the folder that has the reports to remove, change the view type to "list" instead...

2 things come to mind:
1 - did you run DBCC CHECKDB to ensure the database is not corrupt?
2 - did you check the SQL Server error log for...

Another thing to watch, if you are using an SSIS catalog (might apply to the non-catalog method too), the job doesn't need to reside on the same server as the...

Adding to what has been said, I am slightly confused as to why you would manage the subscriptions for end users.
I understand if the subscriptions are emails being sent...

Adding to Sue's response, if user XXXX doesn't explicitly exist in your database, but is a windows user, they could be a member of an AD group that has permission...

There are a lot of cool things you can do with the filestream and filetables though that you can't do nicely in windows.  Full text searching of file contents for...

Could you provide more information such as the error and information from your logs?

I do not have that problem.  I have my SSIS packages run as a job where...

SSL makes this a whole new beast actually.  You need to encrypt the data before sending it out to the FTP server and decrypt it upon reciept.

I suggest...

You also say you are doing this through visual studio.  Have you tried closing visual studio, removing (or renaming) the .data file related to that report.  If memory serves, the...