A quick look at the different types of cache objects SQL Server 2005 keeps in the procedure cache, from a troubleshooting book I reviewed.
SQL SERVER – 2005 – Explanation of TRY…CATCH and ERROR Handling With RAISEERROR Function
Yes, TRY…CATCH can use the RAISEERROR function. A developer said I never showed it, so here are simple SQL Server 2005 examples with and without it.
SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database
Error 3154 says the backup set holds a backup of a database other than the existing database. Use WITH REPLACE in RESTORE, or drop the old database first.
THROW or RAISERROR
THROW or RAISERROR changes how SQL Server handles severity, formatting, and XACT_ABORT; choose the right pattern for new procedures.
SQL SERVER – FIX : ERROR : 3260 An internal buffer has become full
Error 3260, an internal buffer has become full, hit one of our older servers many times. A reboot and more RAM for the server and SQL Server helped.
Funny SQL Server Error Messages and What They Really Mean
Some real SQL Server error messages read like jokes. Here are my favorite funny SQL Server error messages and what each one is really telling you.
SQL SERVER – Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward
Msg 3117 means the log or differential backup cannot be restored because no files are ready to rollforward. Restore the full backup WITH NORECOVERY first.