According to the documentation, they need view database state permissions:

sys.query_store_runtime_stats (Transact-SQL)

Sue

The select statement and the delete statement are two different, separate statements. The delete statement won't have any knowledge of any aliases in the select statement. I am guessing you...

Another thought - when the files get attached to the mail they are converted to 7-bit ascii and I'm not sure of the increase of size in that process. So...

Try using DENSE_RANK instead of RANK

With a as
( 
Select  
name, score
,DENSE_RANK() OVER (  order by score desc ) as RNK  
from #t 
)
Select *...

It's not really something you manually populate. The permission path displays the group that allows access based on the AD group or groups added as logins. If you have a...

Also try restarting the SQL Server Agent Service to see if subsystem loads.

Sue

You need an SPN, the account to be setup for delegation for Kerberos to work. You're looking for an SPN and no duplicates which is what the tool will do....

Do you have an SPN configured for the database server? The easiest way to check for it and to check the configuration is to use the Kerberos Configuration Manager. You...

That's the error from the SQL Server error log, not the SQLAgent.out file. There are two different error files - one for SQL Server and one for SQL Server Agent....

It still could be an issue with nested groups or something along those lines. Try checking the user_token DMV as that will pick up nested groups. So you add an...

Did you check the SQLAgent.out file as the error indicates?

Sue

It's not natively supported in SSRS 2014. The Powerpoint rendering extension was introduced in SSRS 2016. With SSRS 2014 you would look at a third party product to support the...

Mostly no but it can be yes at times. It's only supported as an upgrade process. Higher level replicas cannot be read and if you fail over to a higher...

I understand that it won't be possible to configure Always on from 2 database to 1 database. Yes it could be done with replication. But Primary as sql 2016...

You may want to consider a third party product to do this, especially if it's for compliance with auditing. One of the advantages of using the third party products is...