Rather than a variable, seems like you'd be better off with a VIEW.

I bet at least one of the values of UserID in your CTE ActionCentreUsers has the value NULL. If so, that is documented behaviour:

Caution

Any null values returned by subquery...

As you're on 2016 you have to use AES_128, AES_192, or AES_256; all other algorithms have been deprecated. As per the documentation if you want to use a different...

Unless i recall incorrectly, using a For Each Loop Container on a file directory will process the files in alphabetical order; so there's no need for a script task here.

Seems like a(nother) good reason to use F5 instead. 🙂

This is because your source and/or Destination don't have Ignore Failure set on Truncation. Open up your Source/Destination node, by double clicking it. Then go to the Error Output Pane....

This is definitely a double hop issue. When you run an SSIS package stored in the SSISDB via SQL (in the case the C# app running the appropriate ones), the...

Is that a question...

FYI: Duplicate post of https://www.sqlservercentral.com/forums/topic/unsure-how-to-define-this-query

Personally, if sap and RP,  are the abbreviations you already use, I would created schemas with those names for the schemas, not A, and R.

one "lurking" problem is, that...

A user is a database object, not a server object. When you execute an SP within a database, the permissions of the user, linked to your login in that database,...

• This reply was modified 6 years, 9 months ago by Thom A. Reason: Answered the OP's bullet points

Thanks Steve. I was more surprised than they hadn't been banned/blocked yet, when they'd made 1/2 posts (that I'd seen) almost every day; even after they'd all been reported. Hopefully...

Is there any chance we can get this account banned or something? I'm getting bored of flagging their posts now. based on their "points" it's seems they posted over...

I don't know if...

Do you mean that in the Advanced pane in the Job Steps properties that you can't change the Logging level from None? So you can't select other options as seen...