posted on Sunday, December 24, 2006 4:24 PM by admin

SQL Server 2005 SP2 December CTP released

The SQL Server 2005 team has released .

Some cool fixes are in this release including:

  • A new datatype for the Enterprise Edition database engine: vardecimal. Similar to varchar, this datatype stores only the precision required by the value. There's even a stored procedure included to estimate the reduction in average row size. Cool!
  • Maintenance Plans can now be executed without installing SSIS. Although Maintenance plans remain SSIS packages, selecting the Database Engine option during installation includes the Integration Services execution engine.
  • Logon Triggers!
  • The ability to return text XML query plans when the XML contains more than 127 nested levels.

Some nice touches for SSIS include:

  • The BypassPrepare property of the Execute SQL Task now defaults to True. (Thank you)
  • A new property - ParameterSize - for string parameters in the Execute SQL Task.
  • More variable comboboxes - less variable textboxes.

There are enhancements and improvements to other SQL Server components including:

  • Scripting
  • Management Studio Reports
  • Database Mail
  • The Copy Database Wizard
  • Backup and Restore
...just to name a few!

:{> Andy

Technorati Tags: SQL Server 2005 SP2 December CTP

Comments

# 2006 - the Year in Review

Sunday, December 31, 2006 1:43 PM by Applied Visual Studio Team System

This is probably my last post of 2006. It's been a good year. Not perfect, but very good.

SQL Server...