If only it would work.

It always generates this error  

did you also try using double quotes ? "," ( it's command line, not tsql)

This is the link holding the part that causes your confusion:

Performance improvements in tempdb for SQL Server

check the "mode" parameter of the sys.dm_db_physical_stats function

As this is the only clustered instance which produces these warnings and errors, we suspect SentinelOne - which we are testing on one of the nodes.

We moved the instance to...

Please do keep in mind, if in case of major DRP, starting from scratch, you could end up with a partially working engine if you just install the latest version...

Using Set HADR OFF you're telling the engine to forget the whole content of the replica !

January 27, 2023 at 1:44 pm

#4142412

did you try granting the account "view definition" on these specific databases ?

Using "any database" should indeed cover it all, but ...

use [yourdb]

create user ...

GRANT view definition...

tempdb version store is always used whenever snapshot isolation is used with any query or database !

Most common mistake is to put data into a varbinary(max) column data is frequently needed for filtering etc.

IMHO that is not what this data type is intended for. ( with...

I hope your tenants don't have direct ( e.g. SSMS ) access to the database with mixed-tenant information in the objects.

CustomerAcctNo  DECIMAL(9, 2)  ???  1234567.02 ?

GPF   DECIMAL(9, 2)  ?? you expect big tanks ? 9999999.99 GPF

Rebate   DECIMAL(3, 2) ?? don't you expect rabates to potentially be > 9,99

have you tried Select ... from morerecenttable EXCEPT select ... from oldersnapshot

This gives you new and modified rows. Having that set, you can compare with individual columns

don't use dynamic sql in your stored procedures! ( or use only parameterized queries with the semi generated sql )

don't grand datareader/datawriter !! Only grant exec for sprocs it is...

I would say "Yes" as it is a logged and persisted operation.

Easy to check using sys.dm_db_stats_properties for a given statistics.