Scott,

      The procedure returns no rows. Something also interesting is

      after deleting the table, the sysobjects table in

     the master DB indicates the table is still registered,

     but not registered in  sysobjects table...

Try http://support.microsoft.com/kb/290991/en-us

Best,

Ed

I believe your on to something. Your last query returns rows of 5 objects, two of them table objects that a select * from returns

"invalid object" One being changetableowner which...

We crossed e-mails, I'll try your last message.

Interesting, now I have row information using your last query.

The wyantetest is listed in the Table_Schema for changetableowner

Table_Name. However I still receive a "Invalid object name" when

I launch a Select...

Interesting, your last query returns 4 columns, Table_catalog, Table_Schema, Table_Name, Table_Type, but no row information.

Same results on a test server.

What could I be doing wrong?

R.,

Ed

John,

Yes, I do a refresh after every modification. The new query returns

the same results. Interesting when I replace 'wyantetest' with

any other table object or security login, it returns the same...

John,

It is a table and not a view or stored procedure or function.

The results of the your query are two columns, one table_schema and

the other is table_name, and no row...

Ninja,

     Yes I can drop and recreate new objects the the wyantetest username, but

     Not...

affimative

Thanks for responding John. Even though I use the new owner (wyantetest.changetableowner), or (hboffice.wyantetest.changetableowner) wich includes the domain, I receive the same error. Any ideas?

Thanks,

Ed

Thanks. Wouldn't survive w/o all of you.