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 MoreSQLAuthority News – Book Review – SQL Server 2005 Management and Administration (Paperback)
SQL Server 2005 Management and Administration (Paperback) by Ross Mistry (Author), Chris Amaris (Author), Alec Minty (Author), Rand Morimoto (Author) Link to Amazon Short Summary: SQL SERVER 2005 is a trusted database platform that provides organizations a competitive advantage by allowing them to obtain faster results and make better business…
Read More
SQLAuthority News – 1 Million Visitors in last 1 year – [Update 2019]
It is indeed a bit day for me. I am very happy that I have 1 million visitors in just last 1 year. Read my story of 365 days.
SQLAuthority News – Microsoft Synchronization Services for ADO.NET v2.0 CTP1
Microsoft Synchronization Services for ADO.NET provides the ability to synchronize data from disparate sources over two-tier, N-tier, and service-based architectures. Rather than simply replicating a database and its schema, the Synchronization Services application programming interface (API) provides a set of components to synchronize data between data services and a local…
Read More