Errata

Microsoft® SQL Server® 2008 Administrator's Pocket Consultant

Errata for Microsoft® SQL Server® 2008 Administrator's Pocket Consultant

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date submitted Date corrected
Printed
Page 271
"Working with the Administrators Group

Paragraph in book reads: "The Administrators group is a local group on the database server. [...] In SQL Server, this group is granted the sysadmin server role by default."

http://msdn.microsoft.com/en-us/library/cc281849%28v=SQL.100%29.aspx
"New SQL Server 2008 installations no longer add the local Windows Group BUILTIN\Administrators to the SQL Server sysadmin fixed server role."

Note from the Author or Editor:
New SQL Server 2008 installations no longer add the local Windows Group BUILTIN\Administrators to the SQL Server sysadmin fixed server role.

 Rich Weissler  Sep 11, 2011 
Printed
Page 273
Last paragraph before the "Note"

Paragraph confuses object ownership and schema. The paragraph looks to provide correct information for SQL 2000 (http://msdn.microsoft.com/en-us/library/aa905163%28v=sql.80%29.aspx), not SQL 2005 and 2008 (http://msdn.microsoft.com/en-us/library/ms190387.aspx).

Note from the Author or Editor:
Final two sentences in paragraph should state: For example, if GOTEAM is a member of the sysadmin server role and creates a table called Sales, Sales belongs to dbo and is qualified as dbo.Sales, or simply Sales. However, if GOTEAM?s default schema is the GOTEAM schema and GOTEAM is not a member of the sysadmin server role and creates a table called Sales, Sales belongs to GOTEAM and must be qualified as GOTEAM.Sales.

 Rich Weissler  Sep 11, 2011