>>What is the exact error you're getting and what is the script to create it so I can test the same?
>>
>>Also, your syntax seems to be a bit wrong according to DROP INDEX
>>
>>

>>DROP INDEX ReplyNoMember ON dbo.Reply

>
>I provided the correct syntax in the other message.

Right, your syntax was incorrect - I made a quick check in BOL and found it as well (probably the same time as you did yourself).