Click here to Skip to main content
11,481,265 members (62,873 online)
   

Database

 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult23-Jan-13 16:37
memberPIEBALDconsult23-Jan-13 16:37 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro23-Jan-13 17:16
memberIgaBaro23-Jan-13 17:16 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult23-Jan-13 17:26
memberPIEBALDconsult23-Jan-13 17:26 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro23-Jan-13 17:58
memberIgaBaro23-Jan-13 17:58 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult23-Jan-13 17:59
memberPIEBALDconsult23-Jan-13 17:59 
AnswerRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
Richard MacCutchan24-Jan-13 0:22
mvpRichard MacCutchan24-Jan-13 0:22 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult24-Jan-13 6:48
memberPIEBALDconsult24-Jan-13 6:48 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro24-Jan-13 6:54
memberIgaBaro24-Jan-13 6:54 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult24-Jan-13 7:00
memberPIEBALDconsult24-Jan-13 7:00 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro24-Jan-13 8:11
memberIgaBaro24-Jan-13 8:11 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult24-Jan-13 8:56
memberPIEBALDconsult24-Jan-13 8:56 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
Richard MacCutchan24-Jan-13 23:35
mvpRichard MacCutchan24-Jan-13 23:35 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro24-Jan-13 6:51
memberIgaBaro24-Jan-13 6:51 
Questioncreated tables not dropped in a transaction rollback Pin
Danzy8320-Jan-13 17:13
memberDanzy8320-Jan-13 17: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 Pin
Mycroft Holmes20-Jan-13 17:32
memberMycroft Holmes20-Jan-13 17:32 
AnswerRe: created tables not dropped in a transaction rollback Pin
Eddy Vluggen21-Jan-13 3:06
mvpEddy Vluggen21-Jan-13 3:06 
AnswerRe: created tables not dropped in a transaction rollback Pin
Shameel21-Jan-13 23:08
memberShameel21-Jan-13 23:08 
GeneralRe: created tables not dropped in a transaction rollback Pin
jschell22-Jan-13 9:16
memberjschell22-Jan-13 9:16 
GeneralRe: created tables not dropped in a transaction rollback Pin
Shameel23-Jan-13 0:46
memberShameel23-Jan-13 0:46 
QuestionChange the language for Sql Server 2008 Pin
Thaer Hamael19-Jan-13 2:27
memberThaer Hamael19-Jan-13 2:27 
AnswerRe: Change the language for Sql Server 2008 Pin
PIEBALDconsult19-Jan-13 6:29
memberPIEBALDconsult19-Jan-13 6:29 
AnswerRe: Change the language for Sql Server 2008 Pin
Mycroft Holmes19-Jan-13 15:19
memberMycroft Holmes19-Jan-13 15:19 
Questionsql server 2008 Pin
Kapilkp18-Jan-13 0:25
memberKapilkp18-Jan-13 0:25 
QuestionRe: sql server 2008 Pin
Eddy Vluggen18-Jan-13 2:30
mvpEddy Vluggen18-Jan-13 2:30 
GeneralRe: sql server 2008 Pin
Kapilkp21-Jan-13 0:06
memberKapilkp21-Jan-13 0:06 
GeneralRe: sql server 2008 Pin
Eddy Vluggen21-Jan-13 2:15
mvpEddy Vluggen21-Jan-13 2:15 
GeneralRe: sql server 2008 Pin
PIEBALDconsult21-Jan-13 5:57
memberPIEBALDconsult21-Jan-13 5:57 
AnswerRe: sql server 2008 Pin
PIEBALDconsult18-Jan-13 5:01
memberPIEBALDconsult18-Jan-13 5:01 
Questionsql server Pin
yogika17-Jan-13 20:15
memberyogika17-Jan-13 20:15 
AnswerRe: sql server Pin
Eddy Vluggen18-Jan-13 2:37
mvpEddy Vluggen18-Jan-13 2:37 
AnswerRe: sql server Pin
Richard Deeming18-Jan-13 2:37
memberRichard Deeming18-Jan-13 2:37 
GeneralRe: sql server Pin
Eddy Vluggen18-Jan-13 3:13
mvpEddy Vluggen18-Jan-13 3:13 
GeneralRe: sql server Pin
Richard Deeming18-Jan-13 3:18
memberRichard Deeming18-Jan-13 3:18 
GeneralRe: sql server Pin
Eddy Vluggen18-Jan-13 3:22
mvpEddy Vluggen18-Jan-13 3:22 
GeneralRe: sql server Pin
PIEBALDconsult18-Jan-13 15:36
memberPIEBALDconsult18-Jan-13 15:36 
AnswerRe: sql server Pin
PIEBALDconsult18-Jan-13 5:04
memberPIEBALDconsult18-Jan-13 5:04 
GeneralRe: sql server Pin
Shameel22-Jan-13 5:31
memberShameel22-Jan-13 5:31 
QuestionDo I need a pivot Query? Pin
GREG_DORIANcod16-Jan-13 11:09
memberGREG_DORIANcod16-Jan-13 11:09 
AnswerRe: Do I need a pivot Query? Pin
Mycroft Holmes16-Jan-13 20:36
memberMycroft Holmes16-Jan-13 20:36 
GeneralRe: Do I need a pivot Query? Pin
GREG_DORIANcod17-Jan-13 2:59
memberGREG_DORIANcod17-Jan-13 2:59 
AnswerRe: Do I need a pivot Query? Pin
Jörgen Andersson21-Jan-13 9:58
memberJörgen Andersson21-Jan-13 9:58 
QuestionTotals of each transaction type Pin
Richard.Berry10015-Jan-13 22:38
memberRichard.Berry10015-Jan-13 22:38 
AnswerRe: Totals of each transaction type Pin
Mycroft Holmes15-Jan-13 23:57
memberMycroft Holmes15-Jan-13 23:57 
GeneralRe: Totals of each transaction type Pin
Richard.Berry10016-Jan-13 1:36
memberRichard.Berry10016-Jan-13 1:36 
GeneralRe: Totals of each transaction type Pin
PIEBALDconsult16-Jan-13 4:42
memberPIEBALDconsult16-Jan-13 4:42 
GeneralRe: Totals of each transaction type Pin
Richard.Berry10016-Jan-13 6:36
memberRichard.Berry10016-Jan-13 6:36 
QuestionCustomize color coding in SQL editor window [modified] Pin
biop.codeproject15-Jan-13 21:04
memberbiop.codeproject15-Jan-13 21:04 
AnswerRe: Customize color coding in SQL editor window Pin
Mycroft Holmes15-Jan-13 23:51
memberMycroft Holmes15-Jan-13 23:51 
GeneralMessage Removed Pin
biop.codeproject16-Jan-13 20:26
memberbiop.codeproject16-Jan-13 20:26 
GeneralRe: Customize color coding in SQL editor window Pin
Mycroft Holmes16-Jan-13 20:34
memberMycroft Holmes16-Jan-13 20:34 

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
Web03 | 2.8.150520.1 | Last Updated 22 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid