Skip to main content
Share Your Experience: Take the 2024 Developer Survey

New answers tagged

0 votes

Error in Login securables - SQL Server

I get this error when trying to use SSMS 19.1 (aligned with SQL Server 2019) to connect to SQL Server 2016. When I use SSMS 13.0 (aligned with SQL 2016) it works fine. When you posted this in Sept ...
Brien Malone's user avatar
11 votes
Accepted

What does SQL Server's Error Log actually log?

The name ERRORLOG is historical. It's got all the startup messages, plus the details of all the login failures (which aren't sent to the clients), plus all errors of high severity, plus any raiserror ...
David Browne - Microsoft's user avatar
2 votes

Could not locate statistics in the system catalogs error in SQL Server

Seems like you are bumping into a bug that sometimes happens in AGs, the process which updates the statistics on the secondary can get blocked/hampered from running. Try running this first on the ...
Mike Walsh's user avatar
  • 18.2k
2 votes
Accepted

Foreign Key Error in SQLite3 CREATE TABLE Command

You need also the column PersonID in the table conversations, as it the value of the reference and the Foreign keyis only a constraint for the column PersonID. It indicates that you can add only ...
nbk's user avatar
  • 8,421
0 votes

What defines a "column" in a GROUP BY statement

in the original post you have GROUP BY PostHistory.PostId, PostHistory.UserId, coalesce(Users.DisplayName, PostHistory.UserDisplayName) UserDisplayName is the 4th and for COALESCE to work ...
nbk's user avatar
  • 8,421

Top 50 recent answers are included