I can't access a number of tables on my SQL Server 7.0 database. Have checked using Enterprise Manager and the table does not appear to have any owner. When trying to do anything with the table I always get the following message
{SQL-DMO} The name 'Table Name' was not found in the tables collection. If the name is a qualified name, use [] to seperate various parts of the name, and the try again.
Have tried to change the owner by using sp_changeobjectowner but I am either getting the syntax wrong or it ain't working.
Any ideas??
c8lWhen you look in Enterprise Manager, what do you see?|||Hi,
The only thing I see is the table name (TABLE1), the type (USER) and the creation date. The owner column is blank. Normally you would expect it to say dbo.|||Blank?
What happends when you run this in QA?
SELECT * FROM INFORMATION_SCHEMA.Tables
Maybe you need to close EM and relaunch it. ...|||Thanks for the help but the problem has been resolved, I had to manually update the sysobject table so that the UID for each of the objects that could not be accessed was set to 1. For some reason this was 6.
Cheers
c8l
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment