|
|
Sample Code, Databases, and Updates
Sample database
- Asset sample database
(500KB - recommended). Prepared for users of
SQL Server 2000 (all editions except SQL Server CE). See diagram.
- Script of Asset database (just
code - no data) for SQL Server 2000.
- Asset database prepared for users of all editions of SQL
Server 7.0 including MSDE 1.0 (253KB). This database contains a subset of
procedures which demonstrates features that work with SQL Server 7.0.
- Script of Asset database (just
code - no data) for SQL Server 7.
Published Updates
Sample Database Installation on SQL Server 2000
Installation is described in Chapter 1 of the book. Unfortunately,
there is a formatting error on page 11. The sp_attach_db statement
requires database files to be delimited by single quotes
and naturally, parameters should be delimited with a comma:
EXECUTE sp_attach_db 'Asset',
'c:\program files\sql server\mssql\data\Asset_data.mdf',
'c:\program files\sql server\mssql\data\Asset_log.ldf'
(Again, if the location of the sample database is different on your
machine, change it.)
Sample Database Installation on SQL Server 7.0
Use sp_attach_single_file_db procedure instead of sp_attach_db:
EXECUTE sp_attach_single_file_db 'Asset',
'c:\program files\sql server\mssql\data\Asset_data.mdf'
(Again, if the location of the sample database is different on your
machine, change it.)
Sample Chapter
Chapter 12 - XML Support in SQL Server 2000
Sample Database Diagram
|
