again, I would check the result of your print statement and see what is actually being executed and where the error likely is.

Running your query with the exec commented out...

I would start by taking out that "EXEC" line and use the PRINT line to see what is actually being run.  You are comparing OR inserting an NVARCHAR with an...

At my workplace, we actually use SSIS to pull data across from "live" systems into our reporting database.  SOMETIMES it is a 1:1 copy of the data, sometimes we transform...

That is on you to decide if it is a problem or not.  If it is, then you are going to need to come up with another solution.  If it...

To add to what everyone else has said, network performance could be a bottleneck too.  Those tables don't look like they hold that much data in terms of MB or...

I think my representation of SSIS was a bit off.  What I meant was that SSIS would be used for the data pull from source, the transform of the data...

Bruin's solution works with the exception that it doesn't capture error messages from the scripts.  But what you COULD do is a modified version of Bruin's script, but it does...

Personally, I agree with you Rod.  I think that report writing is more of a "business analyst" role than a DBA or DB Developer role.  BUT that being said, I...

I was just reading the error message as it says "The process encountered a deadlock and is retrying".  This is the expected behavior.

Now, as for long running blocking causing deadlocks,...

My opinion - I do 1 solution per folder in SSRS on a per-subfolder basis.

What I mean is if my SSRS layout is like:

home/

-- Inventoy/

-- invReport1.rdl

--invReprot2.rdl

-- Warehouse/

--WarehouseReport1.rdl

I would have 1...

I would review the logs.  See why it can't execute that stored procedure and possibly find a maintenance window where you can run sp_replrestart for a long period of time...

That sounds like your backups are encrypted. What certificate did you use to back up the database?  I expect you didn't restore that certificate onto the secondary system.

SSC actually has...

Had another thought on this - since you don't want to do updates on the SQL instance, why not look at putting it in Azure in a SQL Managed instance...

Looking at your tables, I don't see how you relate "Products" to an opportunity or order.

I WAS going to say that you could related them by ID on Products and...

It might run without issues for you, but it is not a supported configuration.  A windows update OR a SQL update could break the SQL instance on that server.

If it...