Some features, including triggers and sparse columns, work normally as long as they do not reference the encrypted column, even indirectly using commands such as SELECT * FROM foo". Get started ...

SQL Server Drill Down SQL Server Drill Down explores all aspects of Microsoft SQL Server and related applications, with a particular emphasis on issues of interest to SQL Server data professionals.

Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting.