Performing case sensitive comparison in SQL 2005

Using following query, you can perform case sensitive comparison for strings in SQL 2005 even if your database was configured for case insensitive comparison:

SELECT UserId, email
FROM aspnet_membership
WHERE email = 'test@test.com' COLLATE SQL_Latin1_General_CP1_CS_AS