Replies |
Akiii
Posted on: 7/9/2012 2:11:55 AM
|
Level: Bronze | Status: [Member] | Points: 25
|
You don't have a backup of the database ?
Thanks and Regards
Akiii
Nuwan, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|
Nuwan
Posted on: 7/9/2012 3:35:59 AM
|
Level: Starter | Status: [Member] | Points: 25
|
Actually I have old backup... It not included new data.
Rathnayake
Nuwan, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|
Akiii
Posted on: 7/9/2012 3:45:22 AM
|
Level: Bronze | Status: [Member] | Points: 25
|
I don't think that it is possible. Whenever running a delete or update you should always use BEGIN TRANSACTION, then COMMIT if successful or ROLLBACK if not. Have you done that ?
Akiii
Nuwan, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|
Johnbhatt
Posted on: 7/9/2012 3:48:30 AM
|
Level: Starter | Status: [Member] | Points: 25
|
Nuwan, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|
Nuwan
Posted on: 7/9/2012 4:01:30 AM
|
Level: Starter | Status: [Member] | Points: 25
|
Actually I only do "delete from table1" run that query
Rathnayake
Nuwan, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|
I think it not possible.
Thanks n Regards
Bhupendra Tiwari
Nuwan, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|
Ranjeet_8
Posted on: 7/9/2012 7:48:05 AM
|
Level: Gold | Status: [Member] | Points: 25
|
Nuwan, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|
Hi
I also think that it is impossible
but as John Bhatt post a link i read review and many people say that its working fine for some table for sql server 2005 and above
Really that's nice
Regards
R D Patel
Nuwan, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|
Muhsinathk
Posted on: 9/4/2012 6:23:54 AM
|
Level: Bronze | Status: [Member] | Points: 25
|
Hi,
I also think that it is not possible.
When you delete datas from database, please use TRANSACTION.
DECLARE @CustomerID AS int
SET @CustomerID=''
BEGIN TRY
BEGIN TRANSACTION;
IF EXISTS(SELECT * FROM Customer WHERE CustomerID=@CustomerID)
BEGIN
DELETE FROM Customer WHERE CustomerID=@CustomerID
PRINT 'DELETED'
END
COMMIT TRANSACTION;
END TRY
BEGIN CATCH
PRINT 'Unexpected error occurred!'
ROLLBACK TRANSACTION;
END CATCH
Nuwan, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|
Nuwan, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
|