Microsoft SQL Server Management Studio 9.00.1399.00

Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)

Microsoft MSXML2.6 3.0 4.0 5.0 6.0

Microsoft Internet Explorer7.0.5730.13

Microsoft .NET Framework2.0.50727.3053

Operating System5.1.2600

Thanks Craig. That clarifies all my doubts.

Thanks for those queries SQLBOT. Just wanted to know if same will be the qqueries for SQL logins as well ?

Anyone suggest on thsi:

1. If I'm granting db_ddladmin permissions to any user, will that user be getting db_datareader and\or db_datawriter permissions automatically ?

2. The users having db_datareader and db_datawriter roles...

Thanks SQLBOT. Actually I created some mess and had to clean it with Alter Authorization. Thereafter cleaning all the dirt. I started from teh scratch from your code. Probably what...

I'm using windows group only. After creating database user based on two windows groups say sql\Group1 and sql\Group2, i want to assign roles Role1 and Role2 to them, simultaneously. Now...

Well issue may occur where a logon trigger, during periods of domain controller latency, can prevent access due to the security check.

Gianluca, sorry for the confusion. Seems your solution is best way to protect mixed mode authenticated application account.

Thanks. However Isn't there a way to encrypt the password ?

Can anyone suggest ? All I need is to find the optimized way to get only those Tasks having all the values mentioned in input parameter for Col2

If I say i have a set of values but still need informaiton in such a way that only those Tasks containing all those values must come.

Thanks Dave. That was quick and helpful. I will check if that can be optimized but still that was of great help.

Thanks for the information Shawn.

Yes, I have

How come Grant ? I saved it from the Execution plan tab once the query ran successfully.