"SQL SERVER 2005"
Comes with the CLR integration allowing us to write or rather program stored procedures and functions in more programmable languages liek C# and a whole lot of new stuff ...like xml data type, support for XQuery and ranking functions ....and yes the full text searh function and lots more

starting with..the CLR integration....
The .NET framework to be used now .makes it a lot simler to write complex stored procedures which otherwise wud have been complex...(well m not a tech writer ..m just trying to pen down my study on the SQL server 2005 )..especially the ones which require to compute values intermediatedly .....and the ones that need to return aggregate values ..etc etc...all we have to do is create a class in .NET (VB or C#)..create an assembly , then register it in the SQL db engine...and use it .


next talking abt my favourite ...XML data type (coz i really enjoyed using this feature )
Comes with the support to store xml data as column in a table or a variable..with the support to run xml type methods like query( ), exist( ) ,value( ) , and the DML capabilities like modify( )...etc ..

The pivot and unpivot funtions come very handy to rotate results like to change columns of a result set in to rows and rows into columns ....Also the varchar(max)..allows the occupation of the all the max space by data .

Also the ability to notify the end users with SQL db erros (the actual error message ....)...and not to forget the debugging facility into stored proceudures is exciting .


The full text search is one area yet to be explored ..but will cover that too very soon....

Will try to write more stuff on this abt my experience wid SQL Server 2005 ..shortly