Re: full text search sql 2000 and indexed views

You can't full-text index views in SQL 2000.

"Adam P. Cassidy" <Adam P. Cassidy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A037AB93-C657-41D0-B933-9A844F2ACF4B@xxxxxxxxxxxxxxxx
Hilary,

Can you give an example of this? I've tried to create an indexed view that
contains a text column and when I attempt to create the index I get the error:

Msg 1942, Level 16, State 1, Line 2
Cannot create index on view 'Test.dbo.FullTextView'. It contains text,
ntext, image or xml columns.

Here are my steps:


--Set the options to support indexed views.
SET NUMERIC_ROUNDABORT OFF;
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,
QUOTED_IDENTIFIER, ANSI_NULLS ON;
GO
--Create view with schemabinding.
ALTER VIEW dbo.FullTextView
WITH SCHEMABINDING
AS
SELECT Table1.OrderID, TextField1, TextField2
FROM dbo.Table1 JOIN dbo.Table2
ON Table1.OrderID = Table2.OrderID
WHERE Table2.Status = 'Open'
GO
--Create an index on the view.
CREATE UNIQUE CLUSTERED INDEX idxFullTextView_TestIndex
ON dbo.FullTextView (OrderID);


When I run this, I get the error. I would love to be able to accomplish
what you are indicating in order to complete some performance testing since
currently the performance of full text searching frankly is horrible in the
situation I'm looking for.

Adam


"Hilary Cotter" wrote:

You are correct, you can only full-text index indexed views in SQL 2005.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Letford" <Letford@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AAA3603B-F2E6-4FCB-838A-7FC07FF1CBEF@xxxxxxxxxxxxxxxx
> Hi,
> Is it possible to do a full text catalogue on an indexed view in SQL > 2000?
>
> It looks like you can only do tables and the functionality for indexed
> views
> is in SQL 2005, is this correct?
>
> Thanks




.

Relevant Pages

  • Re: AD or ADAM as a user database
    ... SQL system. ... ADAM with SSL will ... Learning how to design LDAP schema isn't hard as there isn't too much to it, ...
    (microsoft.public.windows.server.active_directory)
  • Re: ADAM as a Linked Server
    ... Yes, but as I said, SQL will *not* impersonate the caller when talking to ... It will connect as its service account, ... > ADAM ...
    (microsoft.public.windows.server.active_directory)
  • Re: ADAM and SQL Server
    ... provisioning needs to be done on your account and/or on SQL service account ... > I don't think SQL will impersonate your account when it calls in to ADAM. ...
    (microsoft.public.windows.server.active_directory)
  • Re: ADAM as a Linked Server
    ... The Windows user account has sa server role within SQL ... > privileges to read data in this ADAM instance. ... From a SQLServer_A I can query the ...
    (microsoft.public.windows.server.active_directory)
  • Re: ADAM and SQL Server
    ... I don't think SQL will impersonate your account when it calls in to ADAM. ... think you need to make sure that the service account SQL is running under ...
    (microsoft.public.windows.server.active_directory)
Loading