Re: [WiX-users] transactions in db scripts

2010-05-07 Thread dB .
r doesn't get enough permissions to drop the database or do it's backup). cheers -dB. dB. @ dblock.org Moscow|Geneva|Seattle|New York -Original Message- From: lewisv [mailto:le...@nitorco.com] Sent: Friday, May 07, 2010 9:10 AM To: wix-users@lists.sourceforge.net Subject:

Re: [WiX-users] transactions in db scripts

2010-05-07 Thread Thomas Tomiczek
o say ;) Thomas -Original Message- From: lewisv [mailto:le...@nitorco.com] Sent: 07 May 2010 15:10 To: wix-users@lists.sourceforge.net Subject: [WiX-users] transactions in db scripts I am wondering about how you guys handle transactions in db upgrade scripts. >From what i have seen sq

[WiX-users] transactions in db scripts

2010-05-07 Thread lewisv
I am wondering about how you guys handle transactions in db upgrade scripts. >From what i have seen sql server, does not allow create/alter/drop functions in transactions unless you have some flags sets. First am i correct with this? Next how do you guys go about updating the db? Should i surro