Full Text Image Type

Hi,
Can anybody tell me from which system tables / catalog views can I get the
Full Text Image Type for a Column in SQL 2005 (Yukon).
TIA
PrasadWith
SELECT *
FROM INFORMATION_sCHEMA.COLUMNS
WHERE CHARACTER_OCTET_LENGTH > 8000 OR
CHARACTER_OCTET_LENGTH = -1
you will get all image, varbinary(max), text, varchar(max), ntext,
nvarchar(max) and xml data type columns.
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Prasad" <ekke_nikhil@.yahoo.co.uk> wrote in message
news:O3EPbsw$FHA.4012@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anybody tell me from which system tables / catalog views can I get the
> Full Text Image Type for a Column in SQL 2005 (Yukon).
>
> TIA
> Prasad
>
>

FTS ON View in Yukon ?

I am eargerly awaiting my MSDN Universal, until then I am very
interested to know if Yukon will allow a View to be FT Indexed ? I am
working on a scenario right as we speak that may be worth pushing off
for the moment if SQL 2005 Will support these
Anyone ?
Or do I just need to jump through the hoops as I would have before ?
Chris
My understanding is that only tables are indexable in Yukon.
"WertmanTheMad" <cwertman@.webchamps.com> wrote in message
news:13990782.0410130715.6790b181@.posting.google.c om...
>I am eargerly awaiting my MSDN Universal, until then I am very
> interested to know if Yukon will allow a View to be FT Indexed ? I am
> working on a scenario right as we speak that may be worth pushing off
> for the moment if SQL 2005 Will support these
> Anyone ?
> Or do I just need to jump through the hoops as I would have before ?
> Chris
|||Chris,
Yukon (SQL Server 2005) will support FT Indexing on Partition Views, i.e..
materialized views and not "normal" views.
See SQL 2000 BOL title "CREATE VIEW" for more information on Partition
Views. Is this type of view possible in your scenario?
Thanks,
John
"WertmanTheMad" <cwertman@.webchamps.com> wrote in message
news:13990782.0410130715.6790b181@.posting.google.c om...
> I am eargerly awaiting my MSDN Universal, until then I am very
> interested to know if Yukon will allow a View to be FT Indexed ? I am
> working on a scenario right as we speak that may be worth pushing off
> for the moment if SQL 2005 Will support these
> Anyone ?
> Or do I just need to jump through the hoops as I would have before ?
> Chris
|||Hmm, I dont think so, as my data cannot really be represented how the
Local Partitioned Views require but I will look into it further,
thanks
Chris
"John Kane" <jt-kane@.comcast.net> wrote in message news:<epl#$kUsEHA.2720@.TK2MSFTNGP12.phx.gbl>...[vbcol=seagreen]
> Chris,
> Yukon (SQL Server 2005) will support FT Indexing on Partition Views, i.e..
> materialized views and not "normal" views.
> See SQL 2000 BOL title "CREATE VIEW" for more information on Partition
> Views. Is this type of view possible in your scenario?
> Thanks,
> John
>
> "WertmanTheMad" <cwertman@.webchamps.com> wrote in message
> news:13990782.0410130715.6790b181@.posting.google.c om...
|||You're welcome, Chris,
While I need to confirm this with the SQL Server 2005 (Yukon) Community
Technology Previews (CTP) releases (post-Beta2 releases), it is possible
that some of the restrictions on Indexed (or Materialized) view might be
relaxed in Yukon, relative to SQL Server 2000 (Sphinx).
Regards,
John
"WertmanTheMad" <cwertman@.webchamps.com> wrote in message
news:13990782.0410150950.a082884@.posting.google.co m...
> Hmm, I dont think so, as my data cannot really be represented how the
> Local Partitioned Views require but I will look into it further,
> thanks
> Chris
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
news:<epl#$kUsEHA.2720@.TK2MSFTNGP12.phx.gbl>...[vbcol=seagreen]
i.e..[vbcol=seagreen]