Suitable de-fanged:
<!--
<DirectoryRef Id="InstallDirectory">
<Component Id="AssignServerPermissions" Guid="NEED-A-GUID-HERE"
Win64="yes" KeyPath="yes">
<sql:SqlString ContinueOnError="no" ExecuteOnInstall="yes"
Id="CreateLogin" Sequence="1" ExecuteOnReinstall="yes" ExecuteOnUninstall="no"
SQL="IF NOT EXISTS(SELECT name FROM sys.server_principals WHERE name =
'[NTDOMAIN]\[NTACCOUNT]') BEGIN CREATE LOGIN [\[][NTDOMAIN]\[NTACCOUNT][\]]
FROM WINDOWS END" SqlDb="DbMaster" User="DbUser" />
<sql:SqlString ContinueOnError="no" ExecuteOnInstall="yes"
Id="AddServerRole" Sequence="2" ExecuteOnReinstall="yes"
ExecuteOnUninstall="no" SQL="EXEC sp_addsrvrolemember '[NTDOMAIN]\[NTACCOUNT]',
'dbcreator'" SqlDb="DbMaster" User="DbUser" />
<sql:SqlString ContinueOnError="no" ExecuteOnInstall="yes"
Id="GrantSelect" Sequence="3" ExecuteOnReinstall="yes" ExecuteOnUninstall="no"
SQL="GRANT SELECT ON SysDatabases TO [\[][NTDOMAIN]\[NTACCOUNT][\]]"
SqlDb="DbMaster" User="DbUser" />
<sql:SqlString ContinueOnError="no" ExecuteOnInstall="yes"
Id="AlterAnyConnectionRole" Sequence="4" ExecuteOnReinstall="yes"
ExecuteOnUninstall="no" SQL="GRANT ALTER ANY CONNECTION TO
[\[][NTDOMAIN]\[NTACCOUNT][\]]" SqlDb="DbMaster" User="DbUser" />
</Component>
</DirectoryRef>
-->
--
John Merryweather Cooper
Build & Install Engineer - ESA
Jack Henry & Associates, Inc.®
Shawnee Mission, KS 66227
Office: 913-341-3434 x791011
jocoo...@jackhenry.com
www.jackhenry.com
-----Original Message-----
From: John H Bergman (XPedient) [mailto:john.berg...@xpdnt.com]
Sent: Thursday, December 06, 2012 10:39 AM
To: General discussion for Windows Installer XML toolset.
Subject: Re: [WiX-users] run Sql commands through wix
Does anyone have an example of this they could share or point me to?
-----Original Message-----
From: Rob Mensching [mailto:r...@robmensching.com]
Sent: Wednesday, December 5, 2012 9:09 AM
To: General discussion for Windows Installer XML toolset.
Subject: Re: [WiX-users] run Sql commands through wix
See the Sql elements in the wix.chm.
On Wed, Dec 5, 2012 at 5:10 AM, Chaitanya <chaita...@pointcross.com> wrote:
> Hi,
>
> I want to run Sql commands through Wix,like insert,update,create.
>
> How to run sql commands through Wix.
>
> Suggest me
>
> Thanks,
>
> Chaitanya.
>
>
> ----------------------------------------------------------------------
> -------- LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free
> Trial Remotely access PCs and mobile devices and provide instant
> support Improve your efficiency, and focus on delivering more
> value-add services Discover what IT Professionals Know. Rescue
> delivers http://p.sf.net/sfu/logmein_12329d2d
> _______________________________________________
> WiX-users mailing list
> WiX-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/wix-users
>
--
virtually,
Rob Mensching
http://RobMensching.com LLC
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely
access PCs and mobile devices and provide instant support Improve your
efficiency, and focus on delivering more value-add services Discover what IT
Professionals Know. Rescue delivers http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely
access PCs and mobile devices and provide instant support Improve your
efficiency, and focus on delivering more value-add services Discover what IT
Professionals Know. Rescue delivers http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
NOTICE: This electronic mail message and any files transmitted with it are
intended
exclusively for the individual or entity to which it is addressed. The message,
together with any attachment, may contain confidential and/or privileged
information.
Any unauthorized review, use, printing, saving, copying, disclosure or
distribution
is strictly prohibited. If you have received this message in error, please
immediately advise the sender by reply email and delete all copies.
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
