Re: Missing table

anonymous_at_discussions.microsoft.com
Date: 05/27/04 

Date: Thu, 27 May 2004 10:50:50 -0700

Am I to type out the 2 commands you list, as is? What am
I looking for in the results?
I executed the first one and it gave me a list of 24
items, most saying DBO, while the last ones said
INFORMATION_SCHEMA. What does this mean?

>-----Original Message-----
>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: conflicting object names in sql server 2000
    ... The owner of the object will depend on the user ... On the local database server when it does the select * from ... she must specify the owner: ...
    (microsoft.public.sqlserver.server)
  • Re: Database Security
    ... the rights to execute jobs with the proxy account. ... user at database level and not server. ... >>from 30 legacy systems) These often fail and the owner ...
    (microsoft.public.sqlserver.security)
  • Re: conflicting object names in sql server 2000
    ... On the local database server when it does the select * from ... > michael.xxx Note that michael is the owner of the database. ... it will see if there is one owned by dbo. ...
    (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: Database Owner
    ... Changing the owner with the changedbowner stored procedure ... >> database on the test server can run a stored procedure that can drop ... > test server so the developer will be mapped to 'dbo' if they have a SQL ...
    (microsoft.public.sqlserver.security)