Sample Database and Sample Code

• Asset sample database (900KB - 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.
• Federated servers implementation sample code - Chapter 8

• XML queries, templates, schemas and XSL files - Chapters 13,14,15 (20KB)
• Visual Studio .NET demo projects for SQLXML - Chapter 15 (487KB)
• prDataGenerator (2K)
• TbDbBatchExec - .NET exe program for deploying database objects - 
  Chapter 12 (3KB)
• prBatchExec - stored procedure for deploying database objects - 
  Chapter 12 (2KB)
• TbDbScript - generate database objects - Chapter 12 (2.5KB)
• TbDir2Vss - copy db objects from folder to VSS (2KB).
• LoginSync - how to synchronize logins and users when you restore a database Chapter 10 (2 KB).

Sample Database Diagram