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 – DBCC command to RESEED Table Identity Value – Reset Table Identity
DBCC CHECKIDENT with RESEED lets you reset table identity to any value. Reseed to 0 so the next insert gets 1, and never go below values already in the table.
SQL SERVER – SQL Server 2005 Samples and Sample Databases (February 2007)
SQL Server 2005 Samples gave learners AdventureWorks and the smaller AdventureWorksLT. Why they mattered and where to find sample databases today.
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.