murach's sample DB

murach's sample DB

posted 2/8/2010  by timmurphy -  Views: [1818] 

It would be nice to use for the exercises at the end of chapters.

Here's the query, from their batch file:

CREATE DATABASE AP
  ON PRIMARY (FILENAME = 'C:\Murach\SQL Server 2008\Databases\AP.mdf')
  LOG ON (FILENAME =     'C:\Murach\SQL Server 2008\Databases\AP_log.ldf')
  FOR ATTACH
GO

CREATE DATABASE AP_AllObjects
  ON PRIMARY (FILENAME = 'C:\Murach\SQL Server 2008\Databases\AP_AllObjects.mdf')
  LOG ON (FILENAME =     'C:\Murach\SQL Server 2008\Databases\AP_AllObjects_log.ldf')
  FOR ATTACH
GO

CREATE DATABASE Examples
  ON PRIMARY (FILENAME = 'C:\Murach\SQL Server 2008\Databases\Examples.mdf')
  LOG ON (FILENAME =     'C:\Murach\SQL Server 2008\Databases\Examples_log.ldf')
  FOR ATTACH
GO

CREATE DATABASE ProductOrders
  ON PRIMARY (FILENAME = 'C:\Murach\SQL Server 2008\Databases\ProductOrders.mdf')
  LOG ON (FILENAME =     'C:\Murach\SQL Server 2008\Databases\ProductOrders_log.ldf')
  FOR ATTACH
GO