Sample Database and Sample Code

• Asset5 sample database (4 MB - recommended). 
  Prepared for users of SQL Server 2005 (all editions except SQL Server 2005 Mobile Edition). See diagram bellow.
   
• Asset5 sample database with SQLCLR assemblies (4 MB). 
  Prepared for users of SQL Server 2005 (all editions except SQL Server 2005 Mobile Edition). See diagram bellow.
  
  Important*: After you attach the database to the server you should run:
  ALTER DATABASE ASSET5 SET TRUSTWORTHY ON
   
• Script of Asset database (35KB - just code - no data) for SQL Server 2005.
• Federated servers implementation sample code - Chapter 8
• Visual Studio .NET demo projects for SQLCLR - Chapter 11-14 (487KB)
• LoginSync - how to synchronize logins and users when you restore/transfer a database - Chapter 19 (2 KB).
• TbDbScript - generate database objects - Chapter 12 (2.5KB)
• ap_BatchExec8 - stored procedure for deploying database objects - 
  Chapter 18 (2KB)
• ap_DataGenerator (2K) - generate insert statements for reloading a table.

• TbDbBatchExec - .NET exe program for deploying database objects - 
  Chapter 18 (3KB)
• TbDir2Vss - copy db objects from folder to VSS (2KB).

*Important

Several readers have contacted me about problems with existing SQLCLR objects in Asset5 database. Unfortunately, by design, SQL Server automatically sets a database in Trustworthy OFF state after attaching it.

After that you will not be able to work with SQLCLR objects, not even to delete them. To solve the problem, execute:

ALTER DATABASE ASSET5 SET TRUSTWORTHY ON

Sample Database Diagram