How To See Who Deleted Rows
Feb 1, 2008
5 accounts have access to database, is it possible to see or log who deleted any records?
Thank you
ADVERTISEMENT
DataSet Rows Being Deleted, But After The Update , The Sql Database Is Not Updated. The Delete Rows Still In The Database.
Jun 4, 2007 Stepping thru the code with the debugger shows the dataset rows being deleted.
After executing the code, and getting to the page presentation. Then I stop the debug and start the
page creation process again ( Page_Load ). The database still has the original deleted dataset rows.
Adding rows works, then updating works fine, but deleting rows, does not seem to work.
The dataset is configured to send the DataSet updates to the database. Use the standard wizard to create the dataSet.
cDependChildTA.Fill(cDependChildDs._ClientDependentChild, UserId); rowCountDb = cDependChildDs._ClientDependentChild.Count; for (row = 0; row < rowCountDb; row++) { dr_dependentChild = cDependChildDs._ClientDependentChild.Rows[0]; dr_dependentChild.Delete(); //cDependChildDs._ClientDependentChild.Rows.RemoveAt(0); //cDependChildDs._ClientDependentChild.Rows.Remove(0); /* update the Client Process Table Adapter*/ // cDependChildTA.Update(cDependChildDs._ClientDependentChild); // cDependChildTA.Update(cDependChildDs._ClientDependentChild); }
/* zero rows in the DataSet at this point */ /* update the Child Table Adapter */ cDependChildTA.Update(cDependChildDs._ClientDependentChild);
Get Number Of Rows Deleted
Feb 1, 2006How do we get the number of rows deleted from a table?
@@rowcount is returning 0
Find Out Who Deleted Rows?
Jan 20, 2004Yesterday, I had an occurence where someone (one of our developers :) ) deleted many vital rows in a database. I was able to recover via a backup but I'd like to see what was run to delete those rows, when and who if possible? I have the transaction log and the _log.ldf.
Can I read those somehow to find out this information? I have since added auditing to said tables, but I'd really like to go back and see what happened?
I do know about Lumigent, but is there a different production/solution?
Thoughts?
Thank you
Retrieve Deleted Rows
Jan 7, 2008Hello all,
I've just deleted some rows by error in one of my tables. I'd like to find out a quick way to retrieve them.
I'm using MSSQL server 2000, version 8.00.194
Thank you in advance
Storing Deleted Rows - Best Method ?
Jun 17, 2002I need a way of being able to store any rows that are deleted from any of 15 tables.
My current thinking is to have one 'Deleted_Records' table with lots of varchar fields (enough to cater for the largest of the 15 tables) and just adding some SQL to the delete triggers of the 15 tables to write a deleted record(s) into it.
I am not anticipating having to read from this table much. Only in case of emergencies i.e. a user makes a bad mistake and deletes accidentally.
Am using SQL7.
Obviously with cascading deletes quite a few records could be deleted in one delete as it were.
I there a better way of handling this scenario ?
many thanks
Paul
Replication Rows Getting Deleted At Publisher
Mar 1, 2005I am using merge replication between two servers.
When i insert data into a perticular table ..the data gets deleted after some time.
Anyone faced this problem?
Counting Number Of Deleted Rows
Mar 8, 2007Hi
I have a stored procedure which deletes a number of rows from a number of different tables. How to i count/return the number of deleted rows in each table?
Here is my stored procedure if it helps:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[usp_delete_entry]
@new_venue_id int
AS
BEGIN
DECLARE@new_customer_id int
SET @new_customer_id = (SELECT customer_id FROM VENUE WHERE venue_id = @new_venue_id)
DELETE FROM FEATURED WHERE venue_id = @new_venue_id
DELETE FROM FACILITIES WHERE venue_id = @new_venue_id
DELETE FROM SIC WHERE venue_id = @new_venue_id
DELETE FROM SUBSCRIPTION WHERE venue_id = @new_venue_id
DELETE FROM ADMIN WHERE venue_id = @new_venue_id
DELETE FROM VENUE WHERE venue_id = @new_venue_id
DELETE FROM CUSTOMER WHERE customer_id = @new_customer_id
END
thanks
Does Anybody Know How To Recover Deleted Rows From A Sql Server Ce 2.0?
Mar 4, 2008If you know how to recover them I will be very pleased whith you.
Thank you.
Log Of Rows Inserted/updated/deleted
Apr 30, 2006HI, I am wondering if it is possible to retreive this information without using row count transform. Can I get the # of rows inserted/updated or deleted by destination from the log?
Thank you,
Ccote
Reporting Services :: How To Insert Deleted Rows From One Table To Another
May 28, 2015I have two tables like hyd,hyd1 but hyd has data ,now I want to delete all rows from hyd at the same time insert deleted rows into hyd1.
View 7 Replies View RelatedDataset.Clear() Doesn't Mark Rows As Deleted
Apr 18, 2007Ok, I've spent a good amount on time on debugging an unupdating scenario in my application. Finally I knew the reason which is very annoying. Either I'm missing something really obvious (I hope so,) or this is a bug.
to reproduce what I'm talking about:
1- create a new win forms application using VS2005 sp1
2- add some SQL Compact Edition data file that have some records from the data menu, you'll get the designer to generate the dataset and everything..
3- drag a table from the data sources window, you'll get the data grid and the navigator on the form
4- add a button and have this in the click event handler:
datasetname.Clear();
TableAdapterName.Update(datasetname);
launch the program, click the button, you'll see the grid get wiped out as it supposed to do. close the program and relaunch. the data is there again (this has nothing to do with the copy always, copy if newer infamous stupidity)
now:
5- edit the click event handler and change it so something like this:
foreach (datasetname.TableRow row in datasetname.Table)
{
row.Delete();
}
TableAdapterName.Update(datasetname);
Launch the program, hit the button, grid wiped out. exit and relaunch. You'll see no data (i.e. the update on table adapter worked alright)
You can also try the GetChanges method on the dataset rightafter you use the clear method and you'd get no deleted records at all.
So, in 100,000+ records dataset, if i need to wipe the thing out and add some new records do i have to loop over every record and call delete (which will take LOTS of time).
I do hope that I'm missing something obvious.
Any help would be highly appreciated.
Thanks.
Order Of Rows In The Inserted And Deleted Psuedo Tables
Aug 15, 2007I have a table that sometimes has modifications to column(s) comprising the primary key [usually "end_date"]. I need to audit changes on this table, and naturally, turned to after triggers.
The problem is that for updates, when the primary key composition changes, I'm not able to relate/join using the primary key - obviously, it no longer matches across INSERTED and DELETED. Now, for a single row update, it's easy to check for updates on PK columns and then deduce what changes were made...
So the real question is: are rows in INSERTED and DELETED always in matching order (1st row in INSERTED corresponds to the 1st row in DELETED...)?
I don't want to put a surrogate key (GUID nor IDENTITY) on the base table if at all possible. INSERT... SELECT from the inserted/deleted tables into a temp table with identity column is fine, and is what I'm currently doing; I would like MVP or product engineer level confirmation that my ordering assumption is correct.
Testing using an identity surrogate key on base table, and selecting from the Ins/del tables, and the temp tables without an order by clause seems to always return in proper order (proper for my purposes). I've tested under SQL 2005 RTM, SP1, SP2, and SP2 "3152".
FYI, I've lost the debate that such auditing is better handled by the application, not the database server...
Aside: why doesn't the ROW_NUMBER() function allow an empty OVER( ORDER BY() ) clause? Will SQL ever expose an internal row_id, at least in the pseudo tables, so we can work around this situation?
Thanks
Mike
Transact SQL :: Recover Deleted Rows From Server Database
Sep 23, 2011My Client Accidently Deleted Somes Rows From Database Now. Now We are Struggling For Almost 2 Days To Get Them Backup. I Even Checked LDF File From Notepad It Have Those Rows But Not Formatted. (Some Similar Text From Some Column Which Got Deleted.)And The Database has no Backup which i Go to Task -> Restore...Server is Running on Sql Server 2008.
View 7 Replies View RelatedHow Rows Get Deleted Auomatically In Sql Table After Specific Interval Of Time
May 17, 2008hi there
i am using .net framework 1.1 with SQL 2000 .
i want the data in table to get deleted automatically after 30 days of inserting data.
so how do i achieve this?
SSIS - Slowly Changing Dimension - Detect Deleted Rows From The Source
Nov 22, 2007
Hi all,
Can you help me to resolve my problem ? I have to do a simple daily backup system. Source : Flat File; Destination : SQL Server. I want to use the Slowly Changing Dimension component to backup only the new and updated row from my source (Flat File) and put them into SQL Server.
But how can I do to detect deleted rows from my source ?
Any suggestions ?
If it's not clear enough, please ask for more details !
GO
ERROR - The Row Value(s) Updated Or Deleted Either Do Not Make The Row Unique Or They Alter Multiple Rows.
Sep 8, 2006i am getting the above error on my database i have 2 rows with the same info on and another 2 with the same info on. example:
ID username password
1 bob bob
1 bob bob
1 john john
1 john john
I know this is a fault with ms sql 2005 however how do i fix it?
Ive found this link which explains everything but how do i start a query. I tried clicking on new query and copying the code. What is table1 meant to be? the database is dbl.tbl_admin. It wont find my database.
Im not sure how to do it anyway.
I need to change it though as its my admin password and Ive given it out to web design companys
http://geekswithblogs.net/allensb/archive/2006/07/27/86484.aspx
Can some 1 read the above page and give me full instructions, I dont know what im doing thanks
info@uktattoostudios.co.uk
URGENT - My DB Has Been Deleted
Sep 27, 2007I just did the dumbest thing ever. I think I have lost my database. i was trying to attach a different db with the same name. but it wasnt able to attach so the i renamed my current db and attached the new db.i dont know what has happened but my old db has been deleted and i cant find it the mdf file for it.... that has been removed for the directory it was in too!! I was using MS SQL Server Managemnent Studio can I undo this somehow?? PLEASE HELP
View 14 Replies View RelatedTo Know Who Deleted The Database
Dec 11, 2000Is it possible to know that who has deleted the database
Thanks in advance
Deleted Database
Jan 21, 2005Our past CIO deleted a SQL Server database because he didn't know what it was or if we needed it. Guess what we do! We were able to undelete the backup files but when we try to restore from it we get the error "No a valid backup" Any ideas?
Thank you for any help. :eek:
Backups Not Deleted.
Jul 25, 2006I am running sql server 2000 on windows 2000. i have my backups set to delete after a week. they are not deleting, can anyone tell me why this is happening?? the backups filled the hard drive.
View 3 Replies View RelatedDeleted Mdf File
Sep 20, 2007I am currently trying to recover a data base that i detached. I have search the computer with *.mdf with out results...
I detached the database from msde 2000 and then installed sql express now when i go to attach the db it is missing, is there away i can recover the db?
Deleted Data
Apr 18, 2007Is there anyway to retreive deleted data (rows) of a table? Unfortunately the backups are corrupt so we can't do a restore.
Thanks
Deleted Packages..??
May 18, 2007Hi,
I accidentaly deleted a package while working on it, intention was to delete another package just above it in solution explorer but the one i was working on got deleted, is there any way to retrieve it...??
any suggestion wud be appreciated.
thanks,
ravi
Nothing much that i can do..!!
Views Are Deleted
Jul 23, 2005I am runnnig Microsoft SQL Server 2000 and have a database that getsdownloaded everymorning from an ftp site. This download contains thenew records and any changes to existing records. However I am runninginto a problem in that I am forced to recreate the views over everytimewe replace the new database with the old one. I've tried restoring thedatabase as well as replacing it and am not sure what I am missing. Iam new to SQL Server and any help would be greatly appreciated.
View 4 Replies View RelatedHelp - Recovering A Deleted Job
Jul 20, 2005Any ideas how I can recover a job that has been deleted (?) from SQL7.0 ? We had one which was used on a regular basis which has nowceased to exists. I've spoken to the people responsible for the serverand was met by blank faces (as usual). They have no idea when it wasdeleted, by whom or when. To make matters worse, they don't think theycan get it off the backup set without a major bit of work to theserver. Suprisingly, none of the users noticed that things had stoppedworking.Unfortunately, I needed to do some work on this in preparation for mymonthly meeting with my boss on Monday. Whilst I'm not to blame, I'dlike to understand a little more about any options available to us forrecovery as he will undoubtedly ask when he finds out.I have an old back up on another server, so it's not the end of theworld re-creating it, but I was under the impression it was backed upproperly. Is this normal or have they missed something ?Are there any ways I can recover this ? What can I get done to thebackup to make sure this is backed up properly ?Thanks in advance.Ryan
View 1 Replies View RelatedRelationships Getting Deleted (MS SQL)
Jul 20, 2005Dear All,I got a wierd problem which I haven't been able to explain.I am working on MS SQL 2000. I don't know for what reason, therelationship between Parent/Child table is getting deleted. When Iopen up the ER diagram in MSSQL Enterprise Manager, I see therelationship line come up for just a split of a second, and disappearsafterwards. This is the second time I am seeing this thing.I realized it when I accidently deleted the rows in the Parent Table.They should not have been deleted as I had associated records in theChild Table (because of Key Constraints).Has anyone ever come across this situation? Do you have anysuggestions?Regards,TinTin
View 1 Replies View RelatedMastlog.ldf Deleted
Feb 5, 2008hi,
I have deleted the mastlog.ldf file how can I restore it?
thanks
Records Don't Get Deleted From The Database!
Sep 17, 2007I am using this code to delete records from a table in the database that has two fields (both are primary keys) I am not getting any error, but nothing gets deleted. Thanks for the help.
Code:protected void btnRemove_Click(object sender, EventArgs e)
{
Remove();Response.Redirect("RegisteredCompanies.aspx");
}protected void Remove()
{
//update database with filename
//Save Changes
connection.Open();using (SqlTransaction trans = connection.BeginTransaction())
{
try
{ SqlHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "spRemoveCompany", new SqlParameter("@Userid", getGdUserID(Profile.UserName)),new SqlParameter("@BusinessID", getBusinessID());
}catch (Exception err)
{
// throw exception
trans.Rollback();
lblStatus.Text = "An error has occurred in the delete process. Please try again.";
}
}
Here is the stored procedure:ALTER PROCEDURE [dbo].[spRemoveCompany]
@Userid uniqueidentifier OUTPUT,
@BusinessID uniqueidentifier OUTPUT
ASDELETE FROM Associations2 WHERE Userid = @Userid AND BusinessID = @BusinessID
RETURN
Reuse Deleted Primary Key Id
Dec 15, 2007Hello, Can I reuse the deleted primary key id? I'm using SQLServer2005. cheers,imperialx
View 6 Replies View RelatedInserted/deleted Table.
Mar 4, 2004Hi,
I am currently working on a MS SQL server 2000.
I would like to access the data inserted or deleted within a trigger. however the built-in tables -- inserted and deleted --- are not accessible. anyone knows why? And is there any other way to do this?
Thanks
Deleted Default DB, Need Hlp Fast!
Mar 27, 2004I have stoopidly enough deleted default Db. That causes Enterprise Manager to be unable to work with my DB's. The default DB I deleted had no other functions other then being default DB, I mean it was outdated, and I had other DB's that contained all my importent work. They are still running, and I can view DB driven site hosted at localhost, even though default DB no longer excist. I am even able to upload new content, or add new users, so this means all my other DB's are fine. I can even see SQL server icon in my bottom right corner of my desktop, and it shows server running.
Now I am in the need of adding tables and rework some of my excisting tables and stored procedures, but I am not able to do that with Enterprise Manager, due to the lack of default Database.
How do I correct this problem? I have gotten one tip of doing the following: EXEC sp_defaultdb 'User', 'DB' but I am not sure what to do with this.....tried to run it from command line, and put my username and the DB I would set to default but nothing happend.
So I need more details, step-by-step guiding will work, as I don't know a hole lot about Enterprise Manager and SQL.
Btw, this is my error in Enterpr.Managr:
A connection could not be established to MyComputerVSDOTNET2003
Reason: Cannot open default database. Login failed..
Please verify SQL server is running and check your SQL server registration prpoerties and try again
Pls tell me there is a way to fix this problem.
Retrieve Deleted Table
Dec 6, 2004hi there,
by mistake i deleted tables in the DB, i heard once that there is a way to retireve it after it has deleted, from the temp or something like that
so is there a way?
Thanks