DBCC CHECKDB checks the logical and physical integrity of all the objects in the specified database. If DBCC CHECKDB ran on database user should not run DBCC CHECKALLOC, DBCC CHECKTABLE, and DBCC CHECKCATALOG on database as DBCC CHECKDB includes all the three command. Usage of these included DBCC commands is listed below.
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
Following error occurs when database which is attempted to be created is smaller than Model Database. It is must that all the databases are larger than Model database and 512KB. Following code will create the error discussed in this post. CREATE DATABASE Tests ON ( NAME = 'Tests', FILENAME =…
Read MoreSQLAuthority News – The Equations of Relativist
F = mg ….. Galileo F = ma ….. Newton E = mc²….. Einstein Reference : Pinal Dave (https://blog.sqlauthority.com) , Great Site – relationary)
Read MoreSQL SERVER – FIX : ERROR Msg 5174 Each file size must be greater than or equal to 512 KB
Following error occurs when database which is attempted to be created is smaller than 512KB. It is must that all the databases are larger than 512KB. It will also follow with another error 1802, which is due to previous error 5174. Following code will create the error discussed in this…
Read MoreSQLAuthority News – SQL Server 2005 Powers Global Forensic Data Security Tool
Note :Â Download Whitepaper by Microsoft Find out how SQL Server 2005 powers a 27 TB data management system called ICE 3.0 that gathers forensic data from more than 85 Microsoft corporate proxy servers into a single database. The Information Security team at Microsoft uses an internal tool called Information…
Read MoreSQL SERVER – 2005 2000 – Search String in Stored Procedure
SQL Server has released SQL Server 2000 edition before 7 years and SQL Server 2005 edition before 2 years now. There are still few users who have not upgraded to SQL Server 2005 and they are waiting for SQL Server 2008 in February 2008 to SQL Server 2008 to release.…
Read MoreSQL SERVER – Versions, CodeNames, Year of Release
Just a day ago, while I was discussing one of the project with another outsourcing team lead in India (who is leading team of 100+ programmer and developer) he asked me if I know all the codenames of the SQL Server releases so far. I knew only two code names…
Read More