A Sqllib error with hr = 0x80004005 and Native Error 17 says SQL Server does not exist or access denied. The simple fix is to enable TCP-IP in Configuration Manager.
SQL SERVER – What is New in SQL Server Agent for Microsoft SQL Server 2005
A TechNet article I liked on what’s new in SQL Server Agent for SQL Server 2005: security, proxy accounts, shared schedules, WMI alerts and Database Mail.
Restore Database Backup Using T-SQL, Step by Step
To restore database backup files safely, read the backup first, then restore under a name and paths you choose. This post builds a small demo database, backs it up, and restores it with MOVE and REPLACE. It also explains the errors that stop most restores.
How to Ask a SQL Server Question That Gets Answered
A SQL Server question that gets answered includes the exact build, full error text, a small repro, and the fixes already tried.
SQL SERVER – FIX : Error 15023: User already exists in current database.
Error 15023: User already exists in current database. I fix it with sp_change_users_login, using Report, Auto_Fix or Update_One to link the user to a login.
SQL SERVER – Primary Key Constraints and Unique Key Constraints
Primary Key and Unique Key both enforce uniqueness, but they differ in the index they create and in NULL handling. Here are the differences and the scripts.
SQL SERVER – Fix : Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved.
Error 14274 shows up when you update or delete SQL Server 2000 jobs after the Windows server was renamed. Here is why it happens and the steps to fix it.