This would require a modification to the SQL custom action, presumably somewhere in SqlSessionExecuteQuery in src\dutil\sqlutil.cpp. If I recall correctly, PRINT statements are treated as errors with severity 0 and therefore turn up in the COM error collection, so the code to log them is mostly already there in SqlGetErrorInfo.
If you're not comfortable with doing this yourself you could suggest it as a feature on the SourceForge issue tracker. -- Mike Dimmick -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bala Shanmugam (Excell Data Corporation) Sent: 27 April 2007 06:22 To: wix-users@lists.sourceforge.net Subject: [WiX-users] SQL loggin in WIX Hi, I am using WIX 2.0 to create the MSI for sql db installation stuffs. I have a SQL script file and it has all SQL statement to create all the objects like Tables, StoredProcedures and Views. For logging purpose I have "PRINT" statement inside SQL scripts. When I install the MSI, I am not able to see those "PRINT" statement in the MSI log file. Is there any way to get the output of each statement/object execution status in the MSI log file? your help would be really appreciated. Thanks, -Bala- ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
