Why can a stored procedure with a wrong table name be created, but not one with a wrong column name? Deferred Name Resolution explains it.
SQL SERVER – Create Check Constraint on Column
A junior developer wrote a trigger to block invalid data. A Check Constraint is simpler. My example limits PostalCode length in AdventureWorks and tests it.
SQL SERVER – Orphaned MS DTC Transaction Information
An orphaned MS DTC transaction kept crashing our IIS application pool. A quick script on sys.syslockinfo shows if you have one, and a Microsoft hotfix solved it.
SQL SERVER – Create Database Error in Windows Vista
A reader on Vista got a create database error, Msg 262 CREATE DATABASE permission denied in database master. The fix is the same one from my earlier post.
SQL SERVER 2005 – FIX Error: 18456 : VISTA Windows Authentication
My Vista Windows Authentication login failed with Error 18456 after installing SQL Server 2005, while sa worked. Adding my login as administrator fixed it.
Reading SQL Server Error Messages Carefully
Reading SQL Server error messages carefully means using number, severity, state, and line to narrow the cause before searching.
SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use – Part 2
Still see Error 3702, cannot drop database because it is currently in use? Why closing Management Studio works and how to find the connection.