You can't control permissions from within your linked server connection.

It depends on the permissions granted to the account that's on linked server (the destination).  If you want to...

We all know accessing production table data is typically a bad idea, we would all probably architect things differently if we could, and we probably all would instantly revoke their...

LOL - yeah that was my first thought...
Apparently they want to audit to see how prevalent it is so that's why I thought I'd reach out here first

Thanks, this is what I thought but wanted to make sure I wasn't missing the obvious.

I've got access to things like Skillsoft and PluralSight but with that type of training I'm still sitting here in my office and easily approachable and/or engulfed with production requests...

Those are some I've heard of, and the types of recommendations I'm looking for - hoping to find something that I'd come out having actually learned something I could directly...

1. Can you provide the errors you're receiving when the secondary attempts to restore the log file?
2. What 3rd party?  Do you mean like Idera, RedGate, or Lightspeed?
3....

So...seriously a silly question but does anyone know how to fill out a support ticket with Microsoft?  Every attempt I've tried on multiple browsers results in this entire section below...

This node has 3 jobs that are nearly identical...and are the only ones we have that are deployed to the MSDB store...so compare the sysjobstep's command for each and noticed...

To further this "oddness", other jobs which are using SSIS on the node are running just fine...

No, no previous existence.  I thought the same thing...perhaps it was first installed with an evaluation copy of SQL Server but don't believe it to be the case.  In any...

Thanks for the write-up Steve, I’m kind of in the same boat...but I think for me it’s more tnullhat I feel intimidated by that language than anything else!

Perry, yes this is a database in full recovery

Any harm in updating the system tables?

In any case, I will change the code we are using to capture the logical files names to pull from the actualy...