EDIT - disregard this post.  Your first image showed up and appears to be answered by scdecade.

Your first image is missing so I am not sure what value you are...

• This reply was modified 5 years, 7 months ago by Mr. Brian Gale.

Granting db_datareader should be all that is needed to have permissions on the view unless you have explicit DENY permissions on the view for a group that user is a...

First, did you try what was suggested in the error:

navigate to the report server on the local server machine

Based on what you have tried, my thought on this is it...

My regex is extremely rusty, but I think this should do what you are wanting as long as your paragraph and note don't contain a "-" character:

-[\s\S]*?-[\s\S]*?(?=-...

With a cursor that should be pretty easy to do.

Something along these lines:

DECLARE @dynamicCount VARCHAR(MAX)
DECLARE @dynamicDelete VARCHAR(MAX)
DECLARE @tblResult TABLE (ID INT IDENTITY(1,1), [Query] VARCHAR(MAX) )
DECLARE cur CURSOR...

I think cursors will be your friend here.

Do a cursor with your select from above and store both into variables then loop through the cursor to execute both SQL statements...

First step would be to check the execution plans for both of these.

Make sure you are getting the same plan in both cases.  If you are getting different plans, this...

I think there is a typo in the answer as it describes query number 2 in the answer but mentions a WHERE clause which only exists in Query number 3. ...

Can you post the entire result of "summary.txt" file (C:\program files\microsoft sql server\130\setup bootstrap\log\summary.txt)?  That usually has the best information about why an install failed.

The messages you psoted there do...

does the query COMPLETE in 0 seconds OR does it show you the execution plan in 0 seconds?

This is a big "it depends" answer.  When you say you are running 15-20 packages daily as "a lot of packages", it makes me wonder how bad my setup is...

Just to throw my 2 cents in this, I have a quick and dirty little script template that I did up ages back to help with sp_who2:

DECLARE...

Was working with a different forum member (Sue_H) and she pointed me in the right direction and pointed me to a process I did that is likely the culprit -...

• This reply was modified 5 years, 7 months ago by Mr. Brian Gale. Reason: edited for truthfulness

Hello Jeff,

Thanks for the reply.  As for the reboot, I had to do some maintenance on our servers on the 18th and at that time we rebooted them.  Unfortunately, rebooting...

My advice - test everything that you want to be certain works after the upgrade.  I would test a backup, a restore, dbcc checkdb, update statistics, reorganize indexes, all features...