Is it possible to specify a JOIN or WHERE clause that joins a SQL Server
Query Table containing some form of Role / Group name with the current
usersActive Directory / NTLM information?

I need to be able to associate a potentially unique role membership with
each record in a SQL Server table. The table is going to be searched via an
ASP.NET application with the results filtered so that the user only sees the
subset of matching records they have permissions for.

This is for an ASP.NET 2.0 solution being run on a network setup with a
domain controller and a SQL Server 2005 Express backend.

Thanks,
Bob

Stored Procedure Help
Conversion failed when converting datetime from character string.
Variable table name in a cursor declaration
Comparing two tables
Need Query help with JOIN