Thanks for the suggestion. We've been using Profiler for this all day to watch the connections and it doesn't appear to be creating new ones. Is there any way SQL Server could be grabbing a connection to do some transactional commits or logging work on a large update or insert even after the script has finished? These upgrades only fail on very large databases and usually an hour or more into the install.
Dana On Fri, Aug 15, 2008 at 6:44 PM, David Reed (SQL) <[EMAIL PROTECTED]>wrote: > I haven't peeked at the code, but based on your description, I'll bet that > it's closing and reopening connections for each SQL string instead of using > connection pooling, etc. > > Fire up SQL Profiler and cap a trace of connection events during the > installation and that will tell you for sure what exactly is happening on > the SQL side. > > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] On Behalf Of Dana Gutride > Sent: Friday, August 15, 2008 06:58 > To: Windows Installer XML toolset developer mailing list; General > discussion for Windows Installer XML toolset. > Subject: [WiX-users] SqlScript Connection Question > > Quick question regarding the way the WiX sql custom actions. When you > specify multiple sql scripts or strings with their associated sequences, > does the custom action open a new connection for each string/script > executed > or does it reuse the connection until it has looped through all of the > scripts it's executing? > > Our reason for asking is we set the database to single user mode when > upgrading, run a ton of scripts and then set it back to multi user mode > again. Something is coming in two-thirds of the way through a big upgrade > and stealing the connection and we are wondering if WiX is doing something > with the connections asynchronously. > > Dana > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
