Three SQL Server 2005 MSIT configuration packs for Configuration Manager 2007, Basic, Intermediate and Comprehensive, built from Microsoft IT settings.
SQL SERVER – DBCC CHECKDB Introduction and Explanation – DBCC CHECKDB Errors Solution
DBCC CHECKDB checks the logical and physical integrity of every object in a database, and it already runs CHECKALLOC, CHECKTABLE and CHECKCATALOG for you.
SQL SERVER – FIX : ERROR Msg 1803 The CREATE DATABASE statement failed. The primary file must be at least 2 MB to accommodate a copy of the model database
Msg 1803: CREATE DATABASE failed because the primary file must be at least 2 MB to hold a copy of the model database. Make it larger than model and 512KB.
SQLAuthority News – The Equations of Relativist
The Equations of Relativist in three lines: F = mg from Galileo, F = ma from Newton and E = mc² from Einstein. A small break from SQL.
SQL SERVER – FIX : ERROR Msg 5174 Each file size must be greater than or equal to 512 KB
Msg 5174 says each file size must be greater than or equal to 512 KB, followed by error 1802. The fix is to create a database larger than 512KB.
SQLAuthority News – SQL Server 2005 Powers Global Forensic Data Security Tool
How SQL Server 2005 powers ICE 3.0, the Microsoft forensic data security tool that gathers data from more than 85 proxy servers into one 27 TB database.
SQL SERVER – 2005 2000 – Search String in Stored Procedure
Two scripts to search a string in stored procedure code, one for SQL Server 2000 using syscomments and one for SQL Server 2005, clearly labeled by version.