All,
I am trying to increase the size of the Description field of search indexer, limited to 2000 char as shown in the stored proc below. I changed it to max but to no avail. Where is the call to this provider in source? Thanks.
/****** Object: StoredProcedure [dbo].[AddSearchItem] Script Date: 09/16/2009 12:20:13 ******/
SET
ANSI_NULLS ON
GO
SET
QUOTED_IDENTIFIER ON
GO
ALTER
@Title
PROCEDURE [dbo].[AddSearchItem]NVARCHAR(200),
@Description
NVARCHAR(2000), ----------------------> offending line
@Author
INT,
@PubDate
DATETIME,
@ModuleId
INT,
@SearchKey
NVARCHAR(100),
@Guid
NVARCHAR(200),
@ImageFileId
AS
INT
DECLARE @ID INT
SELECT @ID = SearchItemIdFROM dbo.SearchItemWHERE ModuleId = @ModuleIDAND SearchKey = @SearchKeyIF @ID IS NULL
BEGIN
INSERT INTO dbo.SearchItem([Title],
[Description]
,
[Author]
,
[PubDate]
,
[ModuleId]
,
[SearchKey]
,
[guId]
,
[HitCount]
,
[ImageFileId]
)
VALUES (@Title,
@Description
,
@Author
,
@PubDate
,
@ModuleId
,
@SearchKey
,
@Guid
,
0
,
@ImageFileId
)
SELECT Scope_identity()
END
ELSE
BEGIN
UPDATE dbo.SearchItemSET [Title] = @Title,
[Description]
= @Description,
[Author]
= @Author,
[PubDate]
= @PubDate,
[ModuleId]
= @ModuleId,
[SearchKey]
= @SearchKey,
[guId]
= @Guid,
[HitCount]
= [HitCount] + 1,
[ImageFileId]
= @ImageFileIdWHERE SearchItemId = @IDSELECT @IDEND