Thanks... I'm sure that both of my database data is in synchronous. I'm using sql server 2000, how do I still see the execution plan for stored proc ?

How do I find the execution plan for the stored proc ? The data and indexes of both the databases are in synchronous.

The data in both the databases are in synchronous.

Dear Helper ...

Thanks a lot for your query... I have modified your query for my requirement. Its completed now.

Really your query helped me. Below is the new query ... FYI...

hello members ...

I'm still finding a query. has anyone got a query for my requirement ?

thanks and regards,

karthik

Hi...

Thanks once again.

This view INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE  does not return me all the columns/constraints of a particular table. It returned me only one constraint details and it seemed to be a PK...

Hi ...

Thanks a lot for your query and response.

Actually I need the names of all the columns (NOT THE NAMES OF CONSTRAINTS) having unique indexes for a particular table in...