so you are creating an index ... good!

But let me tell you when we create the index , we need to consider some points like Index Size, Col Searchability, Whether...

set the permission for the user.

:crazy: DENY ALTER dbo.TableName:: TO USER

Can you post the sample code. so dat it will be more easy to tell you the error.

the error is because of braces u are using. R u creating the...

hey thxs rbarryyoung,

i just missed the <

hey thxs rbarryyoung,

i just missed the <

Taking your answer into consideration say if i have a table in production server having 8 key columns on which frequent search is done and also heavy insert/update/delete operation is...