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