This is my favorite Dilbert. Dilbert is an American comic strip written and illustrated by Scott Adams, first published in the year 1969.
SQLAuthority News – Microsoft SQL Server 2005 MSIT Three Configuration Pack for Configuration Manager 2007
Microsoft SQL Server 2005 MSIT Basic Configuration Pack for Configuration Manager 2007 This configuration pack contains configuration items intended to manage your SQL Server 2005 server roles, and was developed based on settings used by Microsoft IT in the configuration of these server roles. Microsoft SQL Server 2005 MSIT Intermediate…
Read More
SQL SERVER – DBCC CHECKDB Introduction and Explanation – DBCC CHECKDB Errors Solution
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 More