Hello,

At this moment scripts that are run during installation are stripped before
processing.
It is removing comment and spaces before it processes the script.
(I checked in source code, this happens in scasqlstr.cpp line 282 and
further for version 2.0.5805.0)

Is there a good reason for this?

I see what is the disadvantage:

For instance:

When I have a sql script like this:

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
-- This is important information
CREATE PROCEDURE [dbo].[Test]
AS
BEGIN
END
GO

Normal the comment in the script will be stored together with the database
(you can try it with sp_helptext  'Test')

With a wix-created installer this comment is gone.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users

Reply via email to