ScottPletcher is right - LEAD and LAG were introduced in 2012.  I am bad at this recently.  I thought they were a 2016 and newer feature.  Good to know!

I think...

Yeah, for something like backups, I like having short and easy to test/debug scripts rather than "all in one" scripts like Ola's.  That is just my preference, especially since Ola's...

A work around - use shorter filenames for your backups.

I personally don't use Ola's scripts just for the reason you found - if a bug crops up, I either need...

How does this look:

CREATE TABLE [#filetable]
(
[FileID]  VARCHAR(20)
, [GroupID]  VARCHAR(10)
, [Level]  VARCHAR(1)
, [Path]  VARCHAR(255)
, [Filename]  VARCHAR(255)
, [ExpectingResultofPath] VARCHAR(MAX)
);

INSERT INTO [#filetable]
(
[FileID]
, [GroupID]
, [Level]
, [Path]
,...

My opinion (experts correct me if I am off on this) - the "secondary" server when doing log shipping is usually in place for disaster recovery.  If the primary server...

Reading through your SP's something is wrong.  Your "Procedure 1 Data" calls "EXEC Procedure1" twice but puts the data into 2 different tables with 2 different sets of columns.  That's...

according to the documentation for SQL Server 2012 - no:

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/ms143506(v=sql.110)?redirectedfrom=MSDN

Here it says that you are looking at Windows Server 2012 if you want to be in a supported configuration.  That...

I expect that anyone on the forum is going to need more than this.  Since the backup failed, it is obvious (to me) that the restore failed.  Without the backup,...

FKBEYS - I think you are thinking about the calculation wrong or I may be looking at it wrong.  If I understand right, your table contains the columns "Price", "Discount1","Discount2","Discount3",...

I like the idea of moving SSRS to the web server.  I will run that past our IT team.

PolyServe was a fun tool when configured correctly for sure.  We ran...

Thanks for the tips!

We currently have a single SSRS instance, but were toying around with the idea of a second to handle a subdivision of the company.  One instance per...

Are you getting the same error?  If so, my next thought is a trigger on the table is doing something silly.

But, just to address potential other pain points, how large...

Hello Steve,

Thanks for the reply.  I was not aware of the 25 instance limit; that is a good thing to know!

That is a good future state for sure, but current...

What have you tried so far?

I can think of a few ways to do this.  A LEFT JOIN onto table #location where the values match is the approach I'd take. ...

Thanks Thom!  I didn't actually look into the permissions on this, was just going based on our setup.  We have 3 DBA's all of who are sysadmins so just went...