hey,

the problem is I don't have this stored procedure in master. So I'm unable to run it.

if possible, can you pls email me the script for that SP to

I'm very sorry that I'm bothering again. Actually, i couldn't find it in master as well.

thanks for your reply,

I'm using SQL Server 2005 and could not find the SP sp_refreshsqlmodule in my database.

Could you please send me the script, if possible, so that I can...

yes, you are right... It was not clicking out in my mind 🙂

cheers

fantastic, Smith... I didn't think of this!!! I'll work out on my requirement now...

Thanks for your help

yes, it's a production server... Unfortunatley, i don't have any idea on indexing... do you have any link which helps me to identify indexing?

Thanks for your reply..

Last time I did the same for lakhs of records... but when I ran the query DELETE FROM TABLE WHERE .... , it took ages for me...