Hi

I think D is the best choice becuase it Grants permission on required columns while option A revokes permissions and do not grant permission again? 

Khalid

Daily Checklist

1. Check the connectivity of each server over the network. You could do this by pinging the SQL servers twice a day or by clicking...

Hi

  Thanks for your responses. In my view table utilization means number of times the table has been accessed that includes Select, insert, update ,delete and referenced. if we can...

Hi

    Thanks for your kind responses I would like to  clearify that Table Utilization does not mean bigger table . In my view Table Utilization mean how frequently table has...

Hi

        Thanks for response but this method is not showing all the details that I get from show query plan in Query Analyzer. I am not getting I/O Cost and...

Hi

   Thanks for very useful information. I also want to know how sysperfinfo table store counter values does it stores values automatically or do we have to run performance monitor...

thanks Kishore

 It works !I was not aware of to take a T-Log backup of the database before starting the File/Filegroup recovery. I thought that It is not possible to take...

thanks Kishore

 It works !I was not aware of to take a T-Log backup of the database before starting the File/Filegroup recovery. I thought that It is not possible to take...

thanks Kishore

 It works !I was not aware of to take a T-Log backup of the database before starting the File/Filegroup recovery. I thought that It is not possible to take...

thanks Kishore

 It works !I was not aware of to take a T-Log backup of the database before starting the File/Filegroup recovery. I thought that It is not possible to take...