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
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
SQLCMD mode is a script execution mode that simulates the sqlcmd.exe environment and therefore accepts some commands that are not part of T-SQL language. Just enable SQLCMD mode in SSMS (Query menu -> SQLCMD Mode) and the query will run fine. SSMS can also be configured to automatically enable SQLCMD mode in Tools menu -> Options... » read more
Issue: All – Visual Studio has an issue where it saves SQL files as UTF-8-BOM as default, which causes errors when concatenating for our DBAs. Please follow the attached instructions to install the “Fix File Encoding” Extension for Visual Studio. This will fix the issue by saving your SQL files as UTF-8 (without BOM) by... » read more
.NET workload wasm-tools .NET wordload wasm-tools-net6 Visual Studio -> Tools -> Command Line -> Developer Command Prompt Example: ********************************************************************** ** Visual Studio 2022 Developer Command Prompt v17.9.6 ** Copyright (c) 2022 Microsoft Corporation ********************************************************************** C:\Users\xxxxx\source\repos>dotnet workload list Installed Workload Id Manifest Version Installation Source --------------------------------------------------------------------- maui-windows 8.0.7/8.0.100 VS 17.9.34728.123 maccatalyst 17.2.8004/8.0.100 VS 17.9.34728.123 ios 17.2.8004/8.0.100... » read more
In Visual Studio, you can “Unload” project from a solution. It can be useful to unload a project from a solution while resolving circular dependencies between projects or conflicts with different versions of the .NET framework between projects. In Visual Studio, the “Unload Project” option allows you to temporarily remove a project from the solution... » read more
Get Latest from Main Branch In “Git Changes” window, go to Local -> main branch Do a “Pull” to get latest changes from main branch. Switch and select Local -> user branch Hover over “main” branch, right click and select “Merge into Current Branch” Push Changes to Main Branch In “Git Changes” window, “Commit” all... » read more
Create an new folder in your root Git folder. Then use Visual Studio to “Clone a repository” an existing Dev Ops project. https://org01@dev.azure.com/org01/TestDevOps01/_git/TestDevOps01 Files local.settings.json
Error: Getting the following error when trying to run a project from Visual Studio… Can't determine project language from files Solutions: Might be missing local.settings.json file from the project folder. Copy the file from the original project. References: https://github.com/Azure/azure-functions-core-tools/issues/2050
Issue: Database Connection String: Encrypt=True;TrustServerCertificate=False If you recently upgraded your SQL Server Native Client 11.0 (Provider=SQLNCLI11) application to use Microsoft OLE DB Driver 19 for SQL Server (Provider=MSOLEDBSQL19), you might receive error messages that resemble the following messages: [Microsoft OLE DB Driver 19 for SQL Server]: Client unable to establish connection [Microsoft OLE DB Driver... » read more