I'm still on SQL 2000. Sadly it can't be done in SQL 2008 either:
"The view cannot include text, ntext, or image columns, even if they are not referenced in the CREATE INDEX statement." http://msdn.microsoft.com/en-us/library/ms191432.aspx -----Original Message----- From: Maureen [mailto:[email protected]] Sent: 24 April 2011 01:33 To: cf-talk Subject: Re: Problem Using QueryNew Are you still running SQL Server 2000, and if not, is that still the case for the version of SQL you are running? On Sat, Apr 23, 2011 at 5:29 PM, Jenny Gavin-Wear <[email protected]> wrote: > > Hi Maureen, > > I found it is possible to create indexed views and add them to a fulltext > catalog, however, among a longgg list of constraints MS say that the views > cannot contain Ntext fields, which rules out that option for me. > > http://msdn.microsoft.com/en-us/library/aa933148%28v=sql.80%29.aspx ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
