>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.