SQL Express 2005 SP2 VS Bootstrapper manifest – package.xml

<?xml version=”1.0″ encoding=”utf-8″ ?><Package  xmlns=”http://schemas.microsoft.com/developer/2004/01/bootstrapper”  Name=”DisplayName”  Culture=”Culture”  LicenseAgreement=”license.txt”>     <PackageFiles CopyAllPackageFiles=”false”>        <PackageFile Name=”sqlexpr32.exe” HomeSite=”SqlExprExe” PublicKey=”3082010A0282010100CD819638AE5CA2F2C1DFDED0AB958DD63C9D1F8BC35D862E5DF0B172F5ABAC886AB5DAB1227B0BC8C8A54B915E2213E9F9F5239DB5F46E76AEEFEEA43CC7C4C0595C3FABB3733326A662816179A162F46E8895D06EDDC79FD2A451117661BA708A65A1961689A75D81D04466E5DB569E40CAFCDC76242E443000E5D67D7B9511D5581DA3E84F0BC988DCA2D653996CCA63CA996A9A925E4C4D11E82FD35B5B5E5F52A3732DA5BB84450D8C191576CB08DA9AA67015E84DEC69FD5DB26B8FED295137388BC6464915945098B0F468A4D7DE097167749E778C1D856B97EAE75F45CCE0E6710DD16300937B31988E0BB413BDB3D0EEF1DF21EEA96061EE37433DC30203010001″/>        <PackageFile Name=”license.txt”/>    </PackageFiles>    <Commands Reboot=”Defer”>        <Command PackageFile=”sqlexpr32.exe”                  Arguments=’-q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1 ADDUSERASADMIN=1′                 EstimatedInstalledBytes=”225000000″                  EstimatedTempBytes=”225000000″                 EstimatedInstallSeconds=”420″>            <InstallConditions>                <BypassIf Property=”SQLExpressInstalled” Compare=”ValueEqualTo” Value=”0″/>                <BypassIf Property=”VersionNT” Compare=”VersionGreaterThanOrEqualTo” Value=”5.1″/>                <FailIf Property=”AdminUser” Compare=”ValueEqualTo” Value=”false” String=”AdminRequired”/>                <FailIf Property=”Version9x” Compare=”ValueExists” String=”InvalidPlatform”/>                <FailIf Property=”VersionNT”…

2

SQL Express 2005 SP2 VS Bootstrapper manifest – product.xml

<?xml version=”1.0″ encoding=”utf-8″ ?> <Product xmlns=”http://schemas.microsoft.com/developer/2004/01/bootstrapper” ProductCode=”Microsoft.Sql.Server.Express.9.2″>   <RelatedProducts>      <DependsOnProduct Code=”Microsoft.Net.Framework.2.0″ />       <DependsOnProduct Code=”Microsoft.Windows.Installer.3.1″ />       <IncludesProduct Code=”Microsoft.Sql.Server.Express.1.0″ />    </RelatedProducts>   <PackageFiles>      <PackageFile Name=”SqlExpressChk.exe” />    </PackageFiles>   <InstallChecks>      <ExternalCheck Property=”SQLExpressInstalled” PackageFile=”SqlExpressChk.exe” />    </InstallChecks></Product>

2

SQL Express Embedding Webcast – Source Code

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.IO; using System.Reflection; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; using System.Text.RegularExpressions;   namespace EmbeddingDemo_ResourceFile {     class CheckDbVersion     {           #region Declarations           private SqlConnection _connection = new SqlConnection();         private SqlCommand _command = new SqlCommand();         private String _dbPath =…

0

Answers to Embedded Database webcast

Asked: Can you, i.e. is it legal, to sell a product that includes the free SQL Express dB???   Answered: Absolutely, SQL Express is free to download, free to use and free to deploy, you can even sell your application that includes SQL Express. We do ask that you register for redistribution at http://www.microsoft.com/sql/editions/express/redistregister.mspx.  …

3

Questions from the Access to SQL Server migration webcast

  Asked: One of the most difficult tasks of the migrating process was the query upgratings. Most of them had to be all rewrited. PLease coment about queries and the sql of Access and sql of SQLServer. Answered: Access and SQL Server use different SQL dialects. When using the SQL Upsizing Wizard in Access queries…

2