Error 21776 [SQL-DMO]

[eselhassan]

I'm geting the error message "Error 21776 [SQL-DMO]the name 'mytable' was not found in the Tables collection". I was trying to create a non clustered index on 'mytable' using the Wizard from Enterprise Manager.
This is happening to all the talbes in that database. How can I correct this problem. Thnaks

 

[nigelrivett]

Try refreshing the tables in enterprise manager
(or not using e-m to add indexes - use query analyser instead).

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[eselhassan]

You right nigelrivett, Query Analyzer does the trick. What I found out was that when you run Enterprise Manager Wizards against objects owned by anyone other than yourself or dbo, you will receive such an error.

The solution for me was to user either Query Analyzer or Edit server registration to the user that owns the objects, create the index and that was that. Hope this will help someone else.

Thanks