Hi Gail,

Nice article.

However, I have one question. How do you know if an Index is good? I mean we create an index and it works for the query in question....

 Hi,

You can try the following code for insert in the user table. Similarly you can do for the project table.

Here is the code...Hope this helps

create trigger

Thanks a lot!!!

It worked.

Kind Regards

Supriy

I am very sorry, but when i replace the DT with my table name (DT is tablename isn't it?), it gives me message column prefix is invalid.

Also what is the...

No. Its is not a view. Its a table that the stored procedure is querying, and if I try just the table name (and not the top 100...) with the...