If they are sysadmin, there is nothing you can do. Someone who is a member of the sysadmin role has all permissions on the server, and nothing can be denied...

I've done edition upgrades with the DB engine, but not with Analysis Services or Reporting Services. I don't know how SSAS handles it.
Uninstall and reinstall is safer.

Before you disable CDC, find out why it's enabled. It may have a legit and important business use.
Check that the jobs related to CDC are running correctly.

I'd guess that time is to create the backup file (can't recall if it has to be zeroed out). It shouldn't be that slow though.

What's the IO subsystem...

Anyone want to help out here? No DBA, no SQL knowledge.
https://www.sqlservercentral.com/Forums/1890533/Just-new-to-SQL-server-error

No, you shouldn't make them sysadmin.

Can you script out the login, the user and all their permissions? There's probably a deny somewhere, or a missing permission.

Licensing is paperwork. The SQL instance doesn't know whether it's licensed or not, check with the people who buy your software licenses, see what SQL licenses you have, then compare...

Try without the nolock, see if you can reproduce it.

Nolock allows duplicate reads, in addition to dirty reads  (and missed rows as well), so that's a probably cause...

It's a login failure

For some reason, the login doesn't have access to the DB. Speak to your DBA to help you...

They're both terrible.
Shrinking the DB just shrinks all the files in it (including the log file)

Unless you expect the space freed up to not be used in...

Parse-time and binding errors occur before any portion of the code starts to execute, and hence can't be caught by try-catch.

Changing max server memory does flush the plan cache, so I'd recommend that you do it at a quiet time.
Drop it in small amounts.

The majority of SQL's...