Re: Missing table

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 05/27/04 

Date: Thu, 27 May 2004 11:18:31 -0500

I am guessing that the table is "owned" by some other user.

Using Query Analyzer
Connnect to the server
switch to the appropriate database

SELECT TABLE_SCHEMA, TABLE_TYPE, TABLE_NAME FROM INFORMATION_SCHEMA.tables

SELECT crdate, name FROM sysobjects WHERE TYPE = 'u' ORDER BY crdate DESC, name

Regarding the dissapearing data, I am guessing that someone who thought they knew what they were doing (on or around 5/18/2004) created a new table (with a different owner) and dropped the old table. That is speculation, but based on the information that you have provided it sounds logical. The other possibility is that someone deleted the data within the table and changed the owner.

Whatever the case may be, you have some investigation to do! 

-- 
Keith
"Bean" <anonymous@discussions.microsoft.com> wrote in message news:1371901c44404$a95e1610$a601280a@phx.gbl...
> I have a SQL 7.0 server holding our Agency's most critical 
> database. At my deskstop, I link to this database in 
> Access via ODBC drivers. I am linked to a specific table 
> which has disappeared from the server. It does not appear 
> in Enterprise Manager.  I can find no "hidden" attributes 
> to reverse...the table is simply gone. However, I can use 
> the Query Analyser to get a count of records in this table 
> and it returns the correct number of records. Furthermore, 
> all data prior to 5/18/04 has also disappeared. Can anyone 
> help me find this table AND more importantly, help me 
> discover why the data disappeared. No, I have no backups 
> going back that far...... Thanks in advance.

Relevant Pages

  • Re: Missing table
    ... >Using Query Analyzer ... >switch to the appropriate database ... deleted the data within the table and changed the owner. ... >> I have a SQL 7.0 server holding our Agency's most ...
    (microsoft.public.sqlserver.server)
  • Re: SELECT MAX(...) performance in SQL Server/ODBC
    ... Well Query Analyzer uses the ODBC driver to send the command to the server, ... Have you tried using SQL Profiler to profile the events on the server? ... > I work on a commercial software product that is a database application. ...
    (microsoft.public.data.odbc)
  • Re: Invalid authorization specification
    ... > are good enough for Query Analyzer) to no avail. ... > assume that if it couldn't see the server the message ... > doesn't apply to SQL ... >>> ownership chaining has to do with accessing a database ...
    (microsoft.public.sqlserver.security)
  • Select *... but not *
    ... I use Query Analyzer. ... database list on your left hand side. ... SQL Server. ... >permissions to view the column containing credit card ...
    (microsoft.public.sqlserver.server)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)