.NET App Error: Unable to make the session state request to the session state server.
Error: Unable to make the session state request to the session state server. Fix: Make sure the following service is running… ASP.NET State Service
Cannot truncate table because it is being referenced by a FOREIGN KEY constraint.
2 Options… Use a DELETE without a where clause and then RESEED the identity (or) Remove the FK, truncate the table, and recreate the FK. TRUNCATE TABLE xxxxxxxx; — Cannot truncate table ‘tblImageReference’ because it is being referenced by a FOREIGN KEY constraint. DELETE FROM xxxxxxxxxx; Because TRUNCATE TABLE is a DDL command, it cannot... » read more
Only one statement is allowed per batch. A batch separator, such as ‘GO’, might be required between statements.
Error: Getting the following error when trying to build SQL project… Only one statement is allowed per batch. A batch separator, such as ‘GO’, might be required between statements. Fix: I have found the problem. When I added the file in VS I forgot to set Build Action = None from the file properties. So changing that... » read more
Visual Studio Publish Error: A project which specifies SQL Server x as the target platform cannot be published to SQL Server x2
Error: Running into the following error when trying to publish a SQL Server project in Visual Studio… A project which specifies SQL Server 2022 or Azure SQL Database Managed Instance as the target platform cannot be published to SQL Server 2019 Fix: Go to Project -> Properties Change the “Target platform:” to SQL Server 2019
AlwaysOn Error: Either data movement is suspended or the availability replica is not enabled for read access
Error: Msg 976, Level 14, State 1, Line 1The target database, ‘xxxxx’, is participating in an availability group and is currently not accessible for queries. Either data movement is suspended or the availability replica is not enabled for read access. To allow read-only access to this and other databases in the availability group, enable read... » read more