Re: Missing table
From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 05/27/04
- Next message: Steve Holland: "SQL Server 7.0 Life Cycle"
- Previous message: Donald: "Re: Avoid update without where clause"
- In reply to: anonymous_at_discussions.microsoft.com: "Re: Missing table"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 27 May 2004 13:21:15 -0500
Yes, execute the commands within Query Analyzer.
The first piece of sql displays the table owner, type (table or view), and the name of the table.
The second piece of sql displays the creation date for the table as well as the table name.
Knowing these pieces of information might help in your investigation to find out what happened.
You mentioned that "most" are owned by dbo. How about the one table that is causing problems? Is it owned by someone else?
You mentioned that it disappeared from the [tables] view within Enterprise Manager. Hit the "views" node. Is your "table" listed there? Jump out to Query Analyzer and perform
exec sp_helptext YourTableNameGoesHere
That will give you the text of the view (if there is a view with the same name as the table). Perhaps the view is limiting the rows (making it look like some data is missing).
-- Keith <anonymous@discussions.microsoft.com> wrote in message news:13a0501c44413$262bab40$a001280a@phx.gbl... > 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. > >. > >
- Next message: Steve Holland: "SQL Server 7.0 Life Cycle"
- Previous message: Donald: "Re: Avoid update without where clause"
- In reply to: anonymous_at_discussions.microsoft.com: "Re: Missing table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
