Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Row are vanished from Table suddenly in SQL 2008 Expand / Collapse
Author
Message
Posted Monday, July 21, 2014 5:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 11:19 PM
Points: 2, Visits: 3
Hi,

I have an database name ABC. In this DB i have table name XYZ.
This table has the rows more than 1000, but suddenly from yesterday is was showing only 250 rows.
Can you all please suggest on this, what all the possibilities in this?
Post #1594529
Posted Monday, July 21, 2014 5:57 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 11:55 AM
Points: 338, Visits: 747
another user deleted the rows
Post #1594540
Posted Monday, July 21, 2014 6:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 11:19 PM
Points: 2, Visits: 3
Currently no other users are using this DB and admin access are with me only.

While checking have found that the one of the stored procedure was executed for deletion, i have got the last execution but can i found the executor for this procedure???
Post #1594554
Posted Monday, July 21, 2014 11:00 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:40 AM
Points: 35,265, Visits: 31,754
pratiksawant28 (7/21/2014)
Currently no other users are using this DB and admin access are with me only.

While checking have found that the one of the stored procedure was executed for deletion, i have got the last execution but can i found the executor for this procedure???


Unless that proc does it's own logging, you have a server side trace running, or some other feature (CDC???) running, then no. If someone had dropped the table, it would have shown up in the default trace if no one had turned it off.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1594695
Posted Tuesday, July 22, 2014 2:30 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 10:34 AM
Points: 256, Visits: 1,495
You might be able to get something from the log file depending on your recovery model.

Ultimately not a lot you can do with 2000 after the fact, if you haven't set up anything to capture or audit any sort of event.
Post #1595277
Posted Tuesday, August 12, 2014 3:19 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 4:50 PM
Points: 358, Visits: 876
Some use triggers in these cases to potentially record changes to important information. These do add overhead to a tables performance but they exist for a reason.
Post #1602499
Posted Tuesday, August 12, 2014 7:20 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:40 AM
Points: 35,265, Visits: 31,754
...and if the target table is designed properly and the trigger is written properly, they can be nasty fast.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1602536
Posted Tuesday, August 12, 2014 10:47 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:54 PM
Points: 2,008, Visits: 5,482
pratiksawant28 (7/21/2014)
Hi,

I have an database name ABC. In this DB i have table name XYZ.
This table has the rows more than 1000, but suddenly from yesterday is was showing only 250 rows.
Can you all please suggest on this, what all the possibilities in this?


Quick question, what version of SQL Server are you on (select @@version)?
Post #1602558
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse