SQL Server 2005 Express (December Community Technology Preview) is now available

“SQL Server 2005 Express December CTP” is the second community technology preview release of SQL Express 2005 (the first one was in October). The instructions and corresponding CTP executable can be downloaded from here. At this download page, you will find important and detailed install and uninstall instructions, please ensure to follow them carefully to ensure…


SQL Server Express webcast (including demo of Express Manager)

About a month ago, Microsoft released the first Beta version of SQL Server Express. We hope everyone who was interested has had a chance to try out this new product and let us know how we can make the final release better. One of the goals of SQL Server Express was to make it easy…


Using SMO with SQL Express

SMO is the new management model for SQL Server 2005, its included for use with SQL Express. Because SMO is put into the GAC adding a reference to it requires some extra work. As with all of the new Managed APIs provided for use with SQL Server 2005 that are GAC’d, we also put a…


SQL Express Beta 2 available now!

As of this morning SQL Express Beta 2 is available for download from http://lab.msdn.microsoft.com/express/sql/.  Before upgrading please follow all the steps listed on the download page or at http://blogs.msdn.com/sqlexpress/archive/2004/07/21/190738.aspx as upgrading from the Tech Preview can be complicated.


FAQ: How to connect to SQL Express from “downlevel clients”(Access 2003, VS 2003, VB 6, etc(basically anything that is not using .Net 2.0 or the new SQL Native Client))

This is the short version, the longer version is further down, also make sure and review the SQL Express BOL and the Mini BOL. Follow these steps: 1. Make sure express is running correctly (assumes a default install)  Drop to a cmd prompt  Type the following         sqlcmd -S.\sqlexpress  You should get a prompt like…


SQL Express Beta 2 coming soon

The full Beta 2 version of SQL Express is coming soon.  While the Beta 2 release will not add any new features, it does contain many bug fixes that were not in the Tech Preview.  We recommend upgrading to Beta 2 as soon as it is available.<?xml:namespace prefix = o ns = “urn:schemas-microsoft-com:office:office” /> Unfortunately,…


Sample: VB.Net Express and SQL Express Music Manager on MSDN

Brian has a great sample on MSDN that shows off new features in the express SKUs. It really looks cool and pretty simple in terms of code. Please give us feedback as we have more samples planned.   -Euan Garden Product Unit Manager SQL Server Tools