What part are you having problems with?  You say you want to relate No with DocumentNo.  This feels trivial to do as long as those 2 columns ARE actually related.

What...

As a weird question - are C, E, and F the same PHYSICAL disk with different partitions on them?  If so, I would change that structure.  I came to that...

I feel you there.  But if that is what it takes to make the tool then that's what it takes.

Also, I wouldn't say I like Jira... it has its purpose,...

Below is my opinion, I do not work for Jira and have no knowledge of their back-end magic.

I think one of the main reasons that you would want to do...

I think it depends.  What are you looking to monitor?

There are database monitoring tools and SSRS has a SQL Server back end so you may want to monitor that.  Or...

As a random thought, I was looking at this chunk of code:

SET @Sql = 'UPDATE ' + @TableName + ' SET ' + @CustSeqColName + ' =...

Then that is weird.  I've never come across that behavior before.

Any chance that the UPDATE is missing updating something that is causing the DELETE to fail?

My first thought here is that it is rolling back when the cursor ends.  Do you have ANY "ROLLBACK" statements inside your loop or after the loop but before the...

I think it depends on your requirements.  I don't have any Azure instances to monitor, but I like SQL Monitor from RedGate.  The price is right and the tool works...

Scott - that is a good point.  Time of day isn't the best use case for limiting stored procedure execution.  A better use case would be for something like modifying...

Looking at your log there, it says that the edition of SQL Server that installed the service does not support SQL Server Agent.

I would double check your installation media to...

Some people really like the debug feature.  My thoughts on it are that it was a pain to get set up and it seemed to be very inconsistent on my...

The error messages related to the SQL Agent sound like something is broken in MSDB.  If this is a NEW 2019 install, I would do an uninstall and reinstall it...

My opinion - I would refrain from any "execute all" or "read all" permissions.  They are risky.  I would operate on a least privilege model and create roles to access...

I think that that is best practice anyway.  My understanding is that on a server, you want as little overhead as possible which means not installing additional tools like SSMS. ...