Whats the thing you are most excited about in yukon ???

[Enigma]

Hey guys ... long time no discussion ???

What I would like to know is what you are excited about in yukon ... is
it CLR integration or XML as a datatype .... Your views please ...

I am most excited about the enhancements in the t-sql ... hearing
there's a lot to be added b4 the release .

Enigma

[John Kane]

Well, for one thing and it's not very well advitersited, SQL Full Text
Search will be "baked" into T-SQL via the following T-SQL syntax:

CREATE FULLTEXT CATALOG fulltext_calalog_identifier ON FILEGROUP
filegroup_identifier
IN PATH <root path> WITH ACCENT SENSITIVE | INSENSITIVE AS DEFAULT

-- <root path> ::= the root directory (not the complete physical path) for
the catalog

-- CREATE FULLTEXT INDEX statement:

CREATE FULLTEXT INDEX ON base_table_name view_name
(column_identifier) TYPE COLUMN column_identifier 1 LANGUAGE
<language_string>
KEY INDEX index_identifier ON fulltext_calalog_identifier
WITH CHANGE_TRACKING AUTO | XML | NONE
WITH CHANGE_TRACKING MANUAL XML | NONE | AUTO | PARTIAL | OFF |
ALL | NO POPULATION

-- 1 Must be of type [n]char, [n]varchar, [n]text, binay, varbinary,
image, or xml

Regards
John

[John Kane]

One more bit of info...

SQL 2005 (Yukon) Express Technical Express (Beta2) released today:
http://lab.msdn.microsoft.com/express/sql/default.aspx

Alas, FTS is not supported in SSE or whatever springs up to the 3 or 4
letter code for this edition!

John