A disabled Service Broker receiver needs diagnosis before recovery. Read queue flags alongside application evidence, distinguish state from cause and check receiving, enqueueing, activation and poison-message handling separately.
SQL SERVER – Fix : Error: 4064 – Cannot open user default database. Login failed. Login failed for user
Error 4064, cannot open user default database, shows up when a login’s default database was dropped. Connect to master first, then change the default.
SQL SERVER – Fix : Error : Login failed for user ‘UserName’. The user is not associated with a trusted SQL Server connection
Login failed, not associated with a trusted SQL Server connection? I hit it between SQL Server 2008 and 2005 and fixed it with a matching Windows user.
Incorrect Syntax Near: When Compatibility Level Is the Cause
Incorrect syntax near means the parser met a word it did not expect, and a low compatibility level is one cause. This post reproduces the error, shows how to read and raise the level, and covers the other common causes.
Computed Column Data Types: Why the Result Type Surprises You
Your table accepts every insert, then the report dies with an overflow error. Here is why the type is inherited and the cast that fixes it.
SQL SERVER – 2008 – Interview Questions and Answers Part 7
SQL Server 2008 Interview Questions and Answers Part 7: how to rewrite sub-queries with joins or a CTE, what CLR is, and more answers with examples.
SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name
Why does SharePoint stop working after you rename the SQL Server? The old name is still inside SQL Server. How to fix it, and what else holds it.