All tables are invalid objects

From: Keith [MS] (keithbu@online.microsoft.com)
Date: 02/18/03 

From: "Keith [MS]" <keithbu@online.microsoft.com>
Date: Tue, 18 Feb 2003 02:35:27 -0800

Sounds like it might be a security issue. First check the
tables still exist and find out who the owner is by
running sp_tables. Are you currently using SQL statements
of the form select * from pubs..authors? If yes then
replace them with select * from pubs.dbo.authors (replace
dbo with the table owner if not dbo)

My guess is that somehow the account your using to connect
is nolonger the account which owns the tables, ie mapped
to dbo. If this is the case you might want to look at
sp_changedbowner

>-----Original Message-----
>One of my database projects was not working after
changing over to
>Server Config, Windows Authentication. I changed back to
SQL Authentication
>temporarily to make sure that was all that was wrong.
>I then switched back to Windows Authentication and now
all my statements
>to open recordsets are claiming that the TableName is an
invalid object.
>What could I have done to lose access to the tables ?
Does this
>sound related or did I maybe cause this some other way
while
>fiddling around ?
>
>Thanks,
>Fox
>
>
>.
>

Relevant Pages

  • Table record editing permissions
    ... The 'dbo' account means that 'sa' is the owner. ... without being granted permissions. ...
    (microsoft.public.sqlserver.security)
  • Re: Object Created under DBO to different owner name
    ... Yes it would be easier to have the owner dbo. ... My users want the owner to be thier login ... anything and have SQL Server use thier login account. ...
    (microsoft.public.sqlserver.security)
  • Re: DBO Best Practices
    ... lines of always owner qualifying objects... ... someone who are just "a" dbo. ... > doesn't explicitly reference the object's owner (because SQL Server will ... The startup account defines the ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot add new Database Diagrams
    ... I use Windows Authentication, and in SQL Server Query Analyzer, I enter ... > It seems dbo is not the owner of database base, ...
    (microsoft.public.sqlserver.security)
  • Re: Merge replication does not apply schema
    ... when the publisher tables have a different owner than the subscriber tables. ... If in doubt make 'dbo' owner of all your tables and try again ... ... I am running SQL server agent on different account then System witch is default. ...
    (microsoft.public.sqlserver.replication)