Hi,
I am getting the below error on installing an msi which uses <Sql:SqlScript />
to execute a set of stored procedures . I don't think there is anything wrong
with the procedures.
Error:
Action 23:34:21: ExecuteSqlStrings. Executing SQL Strings
ExecuteSqlStrings: Error 0x80040e14: failed to execute SQL string, error:
Incorrect syntax near '»'., SQL key: SqlScript1 SQL string:
-----------------------------------------------------------------------
-- Create all Stored Procedures
The stored procedures are of the form as below.
/****** Object: StoredProcedure [dbo].[Gen_mtblEulaResponse_DelByPK] Script
Date: 11/08/2007 15:13:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id =
OBJECT_ID(N'[dbo].[Gen_mtblEulaResponse_DelByPK]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROCEDURE [dbo].[Gen_mtblEulaResponse_DelByPK]
(
@ResponseGUID VARCHAR(32)
)
AS
SET NOCOUNT ON
DELETE FROM
[mtblEulaResponse]
WHERE
[ResponseGUID] = @ResponseGUID
'
END
GO
Kindly help!
Thanks,
Kiran
-------------------------------------------------------------------------
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
