Errata: The real MCTS sql server 2008 exam 70-432, syngress ISBN 9781597494205

• afw

  SSC Enthusiast

  Points: 151

  More actions

  October 22, 2015 at 10:11 am

  #304439

  I bought this book quite a while ago and never got round to read it. Now I'm planning to take the 2012 exam (70-462) and am going through this book as well. It seems to have issues and there is no errata even after such a long time. Perhaps you have made your own errata? Please join me in creating a community produced errata for this book:

  The real MCTS sql server 2008 exam 70-432,

  Written by Mark Horninger, and others

  Published by Syngress ISBN 9781597494205

  1. Page 29: Correct answer to 9 is B (not A)

  2. Page 73: The alter statement is incorrect. You can either write it in one create database statement like this:

  create database research on primary

  (name = researchprimary, filename = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\resarchprimary.mdf',

  size=10mb, maxsize=700, filegrowth=20),

  filegroup secondary

  (name = researchsecondary, filename = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\resarchprimary.ndf',

  size=10mb, maxsize=700, filegrowth=20);

  or with an combined create and alter database statement like this:

  create database research on primary

  (name = researchprimary, filename = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\resarchprimary.mdf',

  size=10mb, maxsize=700, filegrowth=20);

  alter database research add filegroup research1;

  alter database research add file

  (name = researchsecondary, filename = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\resarchprimary.ndf',

  size=10mb, maxsize=700, filegrowth=20) to filegroup research1;

  3. page 90. To connect to the second instance you need to connect to <YourComputerName>\SQL2