I have general question about non-clustered index working suppose I have 4 non clustered index on my table and I want to know that which non-clustered index is calling form these 4 indexes and is there ant way to use a specific index from these 4 indexes.
Before running your query, hit cntr-M, or select "Include Actual Execution Plan" from the Query menu of SQL Server Management studio. When the query completes, click on the "execution plan" tab of the results window. Scroll around until you find where the plan reads from table in question, and it will tell which index was used.