A Developer’s Guide to SQL Server 2005

Figures

Figure 1-1: SQL Server architecture, version 7 and above 4

Figure 1-2: Preventing managed code from interfering with SQL Server processing or writing over buffers 7

Figure 1-3: Complex types in otherwise-relational tables 9

Figure 1-4: Messages and dialogs 25

Figure 2-1: SQLOS services 29

Figure 2-2: Hosting the CLR 32

Figure 2-3: SQL Server 2005 unhandled exception escalation policy 37

Figure 2-4: .NET Framework marshaling choices. The default is to not allow marshaling 41

Figure 2-5: AppDomains in SQL Server databases 42

Figure 3-1: Pulley system 64

Figure 3-2: Pulley distance calculation 65

Figure 3-3: Create function 65

Figure 3-4: Building assembly 67

Figure 3-5: Using a CLR function 68

Figure 3-6: INFORMATION_SCHEMA.ROUTINES 69 ...