A reader upgraded SQL Server and wanted to convert old RAISEERROR to THROW. I show the same error handled both ways, before and after SQL Server 2012.
SQL SERVER – Fix Error – Package ‘Microsoft SQL Management Studio Package’ failed to load in SQL Server Management Studio
SSMS says Package ‘Microsoft SQL Management Studio Package’ failed to load? I list a few ways to fix it, from reinstalling .NET Framework to running as admin.
SQL SERVER – Fix – Agent Starting Error 15281 – SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the security configuration for this server
SQL Server Agent fails to start with Error 15281 because Agent XPs are turned off? Here is how to enable Agent XPs with sp_configure and start the agent.
SQL SERVER – Fix: Error: Compatibility Level Drop Down is Empty
Fix it when the compatibility level drop down is empty in database properties, with SQL Server 2012 and 2014 on one machine. Cause and fix.
SQL SERVER – Fix – Error 1759 Computed column in table is not allowed to be used in another computed-column definition
Error 1759 appears when a computed column is used in another computed-column definition. Here is a simple repro of the error and how to avoid it.
SQL SERVER – Error – Resolution – Could not allocate space for object in database because the filegroup is full
Could not allocate space for object because the PRIMARY filegroup is full? I hit this error on my laptop, and here is how I resolved it.
MSDTC and Distributed Transactions Across Linked Servers
Understand MSDTC for linked-server transactions, inspect RPC promotion settings, diagnose coordination errors, and compare simpler designs.