August 10, 2007 at 2:51 pm
I DELETED SOME IMPORTANT TABLES APPARENTLY, NAD AM TRYING TO UN-DELETE THEM!!!!
I enter "ROLLBACK TRANSACTION" into query analyzer and running it, but am geting the following error : "The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION."
What does theis cryptic error message mean!!!!!!!
August 10, 2007 at 2:53 pm
That it's time to re-install SQL Server on that machine.
I seriously hope that these are joke posts.
Your friendly High-Tech Janitor... 🙂
August 10, 2007 at 2:59 pm
Hope you had a backup.
August 10, 2007 at 3:01 pm
Isn't there something in DTS I can use?
August 10, 2007 at 3:13 pm
In order to roll back a transaction, you need to begin the query with begin transaction. Without a begin transaction, SQL automatically commits the transaction when it is done running and therefore can not be rolled back.
Not sure but you may be able to restore from the transaction log to a specific point in time. I can't remember if dropped tables are logged in the transaction log or not. If this isn't possible, then a restore from backup is the only other thing you can do.
DTS is on ETL tool and will not help you restore anything. If you have any DTS scripts that do that, then it is just a query written to run from DTS and can be done just as easily from query analyzer.
August 10, 2007 at 3:16 pm
Original post taken down, a good point was made in the other thread.
August 10, 2007 at 3:17 pm
Methinks this is a Friday joke... 😉
August 10, 2007 at 3:30 pm
Please see my post in your other thread:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=389804
August 10, 2007 at 3:42 pm
Wow... a duplicate post.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=389804#bm389838
run this in SQL Server to fix your problem...
select
cast(0x536F72727920726573756C747320636F756C64206E6F742062652072657475726E65642C2062656361757365206170706172656E746C7920796F752064726F7070656420736F6D652073797374656D207461626C65732C20747279207265696E7374616C6C696E672053514C2053657276657220616E6420726573746F72696E6720796F7572207573657220646174616261736573 as varchar(1000))
A.J.
DBA with an attitude
August 10, 2007 at 3:52 pm
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply