Bumping this topic. Thanks for any help.

Thanks, everyone. I'll review the info you provided. The vendor is using this query to determine unused table space:

SELECT TableName
,NumRows
,reservedpages * 8192 / 1024 AS TotalSpace
,pages *...

• This reply was modified 2 months, 3 weeks ago by  webrunner.
• This reply was modified 2 months, 3 weeks ago by  webrunner.

Thanks, Steve! Always appreciate your QOTD.

-- webrunner

Two answers are the same. I wanted to pick that you can't have ORDER BY in a subquery but that wasn't an option.

Hi Johan,

Sorry for my delayed reply. Thanks! I'll check it out.

-- webrunner

Hi Ant-Green,

Thanks so much for this info! I'll test it out.

Thanks again,

-- webrunner

Hello experts,

Following up on this post, I found something interesting.

In the environment mentioned above, one of the AGs hangs with the connection timeout error, but another one connects successfully.

Does anyone...

• This reply was modified 7 months, 1 week ago by  webrunner.

Thanks, Brian.

I'll double-check the firewall (B) possibility. I also think it has to be that.

-- webrunner

I'm a little late to the party due to the repost. But I look forward to reading more on this topic. We had a really terrible EAV implementation, so I...

Found the solution here http://www.batenict.nl/2020/04/03/token-based-server-access-validation-failed-with-an-infrastructure-error-login-lacks-connect-sql-permission/%5B/quote%5D

Hi, thanks for posting that link. As of today, however, it leads to a 404 page. Does anyone have an updated or similar...

Thanks for the interesting question, Steve!

Also to anyone who knows - I guessed it right just based on my experience of never having seen a variable there. But what is...

I can work with just one screen if needed, although it's pretty annoying to have to switch windows back and forth. But practically speaking, as long as I have a...

Thanks for this great fundamental question. I can't believe I got the SQL Server NULL sort order wrong! Time to review the basics.

-- webrunner

I'm ready for the structure of going back to the office more days per week. But I dislike open office plans, so I'm glad to be able to work in...

• This reply was modified 11 months ago by  webrunner.

EDIT: Actually, this thread seems to arrive at your conclusion (Error 19406 being all you need) but I suggest reading through those other articles too anyway. HTH

https://www.sqlservercentral.com/forums/topic/alwayson-availability-failover-

Hi,

You can...

• This reply was modified 11 months, 2 weeks ago by  webrunner.
• This reply was modified 11 months, 2 weeks ago by  webrunner.