Click here to Skip to main content
       

Database

 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmemberPIEBALDconsult24-Jan-13 5:48 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmemberIgaBaro24-Jan-13 5:54 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmemberPIEBALDconsult24-Jan-13 6:00 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmemberIgaBaro24-Jan-13 7:11 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmemberPIEBALDconsult24-Jan-13 7:56 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmvpRichard MacCutchan24-Jan-13 22:35 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 PinmemberIgaBaro24-Jan-13 5:51 
Questioncreated tables not dropped in a transaction rollback PinmemberDanzy8320-Jan-13 16:13 
Hello experts. I have noticed something that is unfamiliar to me in my database knowledge.
 
My application creates tables and inserts initial values into them based on user specifications. More than two tables are created in the process. The table creation and inserts are done within a transaction. When an error occurs, the transaction is rolled back.
 
I just noticed that when the transaction is rolled back, all inserts are erased as expected. However, the tables created within the transaction are not dropped from the database. This is unusual to me. I don't know if I am missing something or that is how it happens with SQL server (2008 R2).
 
Is there any way the tables can be dropped without specifying them one at a time in code? Please help.
AnswerRe: created tables not dropped in a transaction rollback PinmemberMycroft Holmes20-Jan-13 16:32 
AnswerRe: created tables not dropped in a transaction rollback PinmvpEddy Vluggen21-Jan-13 2:06 
AnswerRe: created tables not dropped in a transaction rollback PinmemberShameel21-Jan-13 22:08 
GeneralRe: created tables not dropped in a transaction rollback Pinmemberjschell22-Jan-13 8:16 
GeneralRe: created tables not dropped in a transaction rollback PinmemberShameel22-Jan-13 23:46 
QuestionChange the language for Sql Server 2008 PinmemberThaer Hamael19-Jan-13 1:27 
AnswerRe: Change the language for Sql Server 2008 PinmemberPIEBALDconsult19-Jan-13 5:29 
AnswerRe: Change the language for Sql Server 2008 PinmemberMycroft Holmes19-Jan-13 14:19 
Questionsql server 2008 PinmemberKapilkp17-Jan-13 23:25 
QuestionRe: sql server 2008 PinmvpEddy Vluggen18-Jan-13 1:30 
GeneralRe: sql server 2008 PinmemberKapilkp20-Jan-13 23:06 
GeneralRe: sql server 2008 PinmvpEddy Vluggen21-Jan-13 1:15 
GeneralRe: sql server 2008 PinmemberPIEBALDconsult21-Jan-13 4:57 
AnswerRe: sql server 2008 PinmemberPIEBALDconsult18-Jan-13 4:01 
Questionsql server Pinmemberyogika17-Jan-13 19:15 
AnswerRe: sql server PinmvpEddy Vluggen18-Jan-13 1:37 
AnswerRe: sql server PinmemberRichard Deeming18-Jan-13 1:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.140827.1 | Last Updated 2 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid