Thanks Grant

I accept your point - why is the system giving me a "select permission denied" when using the scalar variable in a select statement, when the user is...

The key difference is a result set. Scalar functions return a value, not a result set. So they're not being "selected" from, they're being executed.

That sure doesn't sound normal. And this is related to the initial question?

Then you have to get a license to run Standard.

Developer edition is the best "free" one you're going to get.

Sounds like you're trying to enabled Query Store on the secondaries. That's only available in SQL Server 2022, not 2019. Here you go.

A) Testing is your buddy. Don't take anyone's word for it. Test it.

B) Probably not. In fact, that's almost the opposite of what I'd want to do. Presumably, guessing here,...

If I answer the questions, what does the job pay and when do I start?---> I Just need a second opinion to make my self much better while answering...

Yep. Could be a real problem. No denying it. But, I tend towards this.

If I answer the questions, what does the job pay and when do I start?

Cause you wouldn't take my answers to those questions and submit them as your own to...

Bugs. Natural and inevitable. And probably perpetual.

I didn't trust virtual machines when we first started using them. And, we had problems. Then, over time, they just became a standard. I...

What? My opinion can't possibly be wrong. HA! Totally kidding.

Yeah, hey, honest people can certainly disagree. Without a doubt our experiences and the lessons we get from the vary. It's...

I'm not...

Never mind. AI lied to me. I'm going with my original answer until I find something otherwise.

Hang on. Might have something else. Give me a sec to do an experiment.