| Author |
Messages |
|
mmcintyre@ormac.com
Posts:8
Send A Message
 |
| 05/06/2008 7:51 PM |
|
I wasn't able to capture the error during installation, but viewing the logs, I get this.
ModuleId: 804
ModuleDefId: 108
FriendlyName: VenexusSearch
ModuleControlSource: DesktopModules/VenexusSearch/ViewVenexusSearch.ascx
AssemblyVersion: 04.08.00
PortalID: 0
PortalName: NDGraphics
UserID: 3
UserName: host
ActiveTabID: 37
ActiveTabName: Search Results
RawURL: /SearchResults/tabid/37/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://dnn2.ndgraphics.com/SearchResults/tabid/37/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.2; .NET CLR 1.1.4322; MS-RTC LM 8)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: dc8d8596-1424-4ceb-a9c9-54ba754fc0b4
InnerException: Cannot use a CONTAINS or FREETEXT predicate on table 'Venexus_BrainDump' because it is not full-text indexed.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: EntitySpaces.Core.esEntityCollection.ExecuteNonQuery
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot use a CONTAINS or FREETEXT predicate on table 'Venexus_BrainDump' because it is not full-text indexed. ---> System.Data.SqlClient.SqlException: Cannot use a CONTAINS or FREETEXT predicate on table 'Venexus_BrainDump' because it is not full-text indexed. at EntitySpaces.Core.esEntityCollection.ExecuteNonQuery(esQueryType queryType, String query, esParameters parms) at EntitySpaces.Core.esUtility.ExecuteNonQuery(esQueryType queryType, String query) at Venexus.Modules.VenexusSearch.ViewVenexusSearch.RecreateFullTextStoredProcedures() --- End of inner exception stack trace ---
Source:
Server Name: IIS01
|
|
|
|
|
xfernal
Posts:76
Send A Message
 |
|
mmcintyre@ormac.com
Posts:8
Send A Message
 |
| 05/08/2008 10:57 AM |
|
Ok,
So I completely uninstalled Seamus and Search modules ... deleted the DesktopModule folders and deleted any database references (tables, etc)[except, I could NOT remove the VenexusSearchCatalog]. I then re-installed the Search module with no issues, the re-installed teh Seamus module and got the following error ...
| StartJob |
Begin Sql execution |
| Info |
Executing 01.00.00.SqlDataProvider |
| StartJob |
Start Sql execution: 01.00.00.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 4: Incorrect syntax near 'fulltext'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) If (left(@@VERSION, 26)) = 'Microsoft SQL Server 2005 ' BEGIN Create fulltext index On dbo.[Venexus_BrainDump] (IndexURL, IndexTitle, IndexWashedContent) Key Index PKVenexusSearchEngine On VenexusSearchCatalog With Change_Tracking Auto END System.Data.SqlClient.SqlException: You must first create a full-text index on table 'dbo.[Venexus_BrainDump]'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) If (left(@@VERSION, 26)) = 'Microsoft SQL Server 2000' BEGIN EXEC sp_fulltext_column 'dbo.[Venexus_BrainDump]', 'IndexWashedContent', 'add' END System.Data.SqlClient.SqlException: You must first create a full-text index on table 'dbo.[Venexus_BrainDump]'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) If (left(@@VERSION, 26)) = 'Microsoft SQL Server 2000' BEGIN EXEC sp_fulltext_table 'dbo.[Venexus_BrainDump]', 'activate' END System.Data.SqlClient.SqlException: You must first create a full-text index on table 'dbo.[Venexus_BrainDump]'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) If (left(@@VERSION, 26)) = 'Microsoft SQL Server 2000' BEGIN EXEC sp_fulltext_table 'dbo.[Venexus_BrainDump]', 'start_full' END |
| EndJob |
End Sql execution: 01.00.00.SqlDataProvider file |
I'm assuming this error screws up the whoel thing ... so I will NOT continue until I head back from you on this. I need to resolve this today. Look forward to your response. |
|
|
|
|
mmcintyre@ormac.com
Posts:8
Send A Message
 |
| 05/08/2008 11:52 AM |
|
I was able to to delete the Catalog and repeated the steps above and got the same error. |
|
|
|
|
xfernal
Posts:76
Send A Message
 |
| 05/08/2008 11:59 AM |
|
| Please answer my question about what version of SQL Server you are using. |
|
|
|
|
xfernal
Posts:76
Send A Message
 |
| 05/08/2008 12:09 PM |
|
There should never be a reason to uninstall and reinstall. It would help us greatly if you provided the information we asked for and actually tried to execute what we suggest. The issue is concerning the full text indexing and whether it is setup on your server or not. Were you about to do what I asked and run the stored procs as described here (http://www.venexus.com/Support/ProductForums/tabid/132/forumid/3/tpage/1/view/topic/postid/160/Default.aspx#160)? Did you get error message?
If this is not successful, please do the following from SQL Server Management Studio (SQL2005) or Query Analyzer (SQL2000):
Run each statement individually and post each message here in this thread:
1. sp_fulltext_database 'enable'
2. EXEC sp_fulltext_catalog 'VenexusSearchCatalog', 'drop'
3. EXEC sp_fulltext_catalog 'VenexusSearchCatalog', 'create'
4. Create Unique Index PKVenexusSearchEngine On [Venexus_BrainDump](IndexID)
If you are running SQL Server 2005:
5. Create fulltext index On [Venexus_BrainDump] (IndexURL, IndexTitle, IndexWashedContent) Key Index PKVenexusSearchEngine On VenexusSearchCatalog With Change_Tracking Auto
If you are running SQL Server 2000:
5. EXEC sp_fulltext_column '[Venexus_BrainDump]', 'IndexWashedContent', 'add'
6. EXEC sp_fulltext_table '[Venexus_BrainDump]', 'activate'
7. EXEC sp_fulltext_table '[Venexus_BrainDump]', 'start_full' |
|
|
|
|
mmcintyre@ormac.com
Posts:8
Send A Message
 |
| 05/08/2008 12:16 PM |
|
Ok,
I ran the FullTextStoredProcedures.sql the Host/SQL as you requested (I did this already by the way) and got this error.
System.Data.SqlClient.SqlException: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.Venexus_BrainDump' because it is not full-text indexed. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /******************************/ /** Create Stored Procedures **/ /******************************/ CREATE PROCEDURE dbo.[Venexus_FullTextQuery_Simple] @RawQuery nvarchar(4000), @Query nvarchar(4000), @TotalRecords int output AS SET @TotalRecords = 0 DECLARE @Results TABLE ([Key] int, Rank int) INSERT INTO @Results([Key], Rank) SELECT [Key], [Rank] FROM CONTAINSTABLE(dbo.[Venexus_BrainDump], *, @Query) DECLARE @SearchID int DECLARE @SearchHits int Set @SearchID = (Select SearchID From dbo.[Venexus_Searches] Where SearchQuery = @RawQuery); Set @SearchHits = (Select SearchHit From dbo.[Venexus_Searches] Where SearchID = @SearchID); If @SearchID IS NOT NULL BEGIN Update dbo.[Venexus_Searches] Set SearchLastDate = GETDATE(), SearchHit = @SearchHits + 1 Where SearchID = @SearchID; END Else Begin Insert Into dbo.[Venexus_Searches] (SearchQuery, SearchHit, SearchDate) VALUES (@RawQuery, 1, GETDATE()); End SELECT TOP 500 dbo.[Venexus_BrainDump].IndexID, dbo.[Venexus_BrainDump].IndexURL, dbo.[Venexus_BrainDump].IndexDate, dbo.[Venexus_BrainDump].Indextitle, convert(nvarchar(255),dbo.[Venexus_BrainDump].IndexWashedContent) As IndexWashedContent, dbo.[Venexus_BrainDump].ModuleID As ModuleID, dbo.[Venexus_BrainDump].TabID As TabID, dbo.[Venexus_BrainDump].FileID As FileID, dbo.[Venexus_BrainDump].IndexSummary, dbo.[Venexus_BrainDump].CategoryID FROM dbo.[Venexus_BrainDump] INNER JOIN @Results R ON dbo.[Venexus_BrainDump].IndexID = R.[Key] Where dbo.[Venexus_BrainDump].IsApproved = 1 AND dbo.[Venexus_BrainDump].IsDeleted = 0 ORDER BY R.Rank DESC System.Data.SqlClient.SqlException: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.Venexus_BrainDump' because it is not full-text indexed. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.[Venexus_FullTextQuery_Mixed] @RawQuery nvarchar(2000), @Query1 nvarchar(4000), @Query2 nvarchar(4000), @TotalRecords int output AS SET @TotalRecords = 0 DECLARE @Results TABLE ([Key] int, Rank int) INSERT INTO @Results([Key], Rank) SELECT [Key], [Rank] FROM CONTAINSTABLE(dbo.[Venexus_BrainDump], *, @Query1) UPDATE R SET R.Rank = R.Rank + 1 FROM @Results R INNER JOIN ( SELECT [Key], [Rank] FROM CONTAINSTABLE(dbo.[Venexus_BrainDump], *, @Query2)) R2 ON R.[Key] = R2.[Key] DECLARE @SearchID int DECLARE @SearchHits int Set @SearchID = (Select SearchID From dbo.[Venexus_Searches] Where SearchQuery = @RawQuery); Set @SearchHits = (Select SearchHit From dbo.[Venexus_Searches] Where SearchID = @SearchID); If @SearchID IS NOT NULL BEGIN Update dbo.[Venexus_Searches] Set SearchLastDate = GETDATE(), SearchHit = @SearchHits + 1 Where SearchID = @SearchID; END Else Begin Insert Into dbo.[Venexus_Searches] (SearchQuery, SearchHit, SearchDate) VALUES (@RawQuery, 1, GETDATE()); End SELECT TOP 500 dbo.[Venexus_BrainDump].IndexID, dbo.[Venexus_BrainDump].IndexURL, dbo.[Venexus_BrainDump].IndexDate, dbo.[Venexus_BrainDump].Indextitle, convert(nvarchar(255),dbo.[Venexus_BrainDump].IndexWashedContent) As IndexWashedContent, dbo.[Venexus_BrainDump].ModuleID As ModuleID, dbo.[Venexus_BrainDump].TabID As TabID, dbo.[Venexus_BrainDump].FileID As FileID, dbo.[Venexus_BrainDump].IndexSummary, dbo.[Venexus_BrainDump].CategoryID FROM dbo.[Venexus_BrainDump] INNER JOIN @Results R ON dbo.[Venexus_BrainDump].IndexID = R.[Key] Where dbo.[Venexus_BrainDump].IsApproved = 1 AND dbo.[Venexus_BrainDump].IsDeleted = 0 ORDER BY R.Rank DESC System.Data.SqlClient.SqlException: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.Venexus_BrainDump' because it is not full-text indexed. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.[Venexus_FullTextQuery_MixedByPortalID] @RawQuery nvarchar(4000), @Query nvarchar(4000), @Query2 nvarchar(4000), @PortalID int, @TotalRecords int output AS SET @TotalRecords = 0 DECLARE @Results TABLE ([Key] int, Rank int) INSERT INTO @Results([Key], Rank) SELECT [Key], [Rank] FROM CONTAINSTABLE(dbo.[Venexus_BrainDump], *, @Query) UPDATE R SET R.Rank = R.Rank + 1 FROM @Results R INNER JOIN ( SELECT [Key], [Rank] FROM CONTAINSTABLE(dbo.[Venexus_BrainDump], *, @Query2)) R2 ON R.[Key] = R2.[Key] DECLARE @SearchID int DECLARE @SearchHits int Set @SearchID = (Select SearchID From dbo.[Venexus_Searches] Where SearchQuery = @RawQuery); Set @SearchHits = (Select SearchHit From dbo.[Venexus_Searches] Where SearchID = @SearchID); If @SearchID IS NOT NULL BEGIN Update dbo.[Venexus_Searches] Set SearchLastDate = GETDATE(), SearchHit = @SearchHits + 1 Where SearchID = @SearchID; END Else Begin Insert Into dbo.[Venexus_Searches] (SearchQuery, SearchHit, SearchDate) VALUES (@RawQuery, 1, GETDATE()); End SELECT TOP 500 dbo.[Venexus_BrainDump].IndexID, dbo.[Venexus_BrainDump].IndexURL, dbo.[Venexus_BrainDump].IndexDate, dbo.[Venexus_BrainDump].Indextitle, convert(nvarchar(255),dbo.[Venexus_BrainDump].IndexWashedContent) As IndexWashedContent, dbo.[Venexus_BrainDump].ModuleID As ModuleID, dbo.[Venexus_BrainDump].TabID As TabID, dbo.[Venexus_BrainDump].FileID As FileID, dbo.[Venexus_BrainDump].IndexSummary, dbo.[Venexus_BrainDump].CategoryID FROM dbo.[Venexus_BrainDump] INNER JOIN @Results R ON dbo.[Venexus_BrainDump].IndexID = R.[Key] WHERE dbo.[Venexus_BrainDump].PortalID = @PortalID AND dbo.[Venexus_BrainDump].IsApproved = 1 AND dbo.[Venexus_BrainDump].IsDeleted = 0 ORDER BY R.Rank DESC System.Data.SqlClient.SqlException: Line 44: Incorrect syntax near 'GO'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.[Venexus_FullTextQuery_SimpleByPortalID] @RawQuery nvarchar(4000), @Query nvarchar(4000), @PortalID int, @TotalRecords int output AS SET @TotalRecords = 0 DECLARE @Results TABLE ([Key] int, Rank int) INSERT INTO @Results([Key], Rank) SELECT [Key], [Rank] FROM CONTAINSTABLE(dbo.[Venexus_BrainDump], *, @Query) DECLARE @SearchID int DECLARE @SearchHits int Set @SearchID = (Select SearchID From dbo.[Venexus_Searches] Where SearchQuery = @RawQuery); Set @SearchHits = (Select SearchHit From dbo.[Venexus_Searches] Where SearchID = @SearchID); If @SearchID IS NOT NULL BEGIN Update dbo.[Venexus_Searches] Set SearchLastDate = GETDATE(), SearchHit = @SearchHits + 1 Where SearchID = @SearchID; END Else Begin Insert Into dbo.[Venexus_Searches] (SearchQuery, SearchHit, SearchDate) VALUES (@RawQuery, 1, GETDATE()); End SELECT TOP 500 dbo.[Venexus_BrainDump].IndexID, dbo.[Venexus_BrainDump].IndexURL, dbo.[Venexus_BrainDump].IndexDate, dbo.[Venexus_BrainDump].Indextitle, convert(nvarchar(255),dbo.[Venexus_BrainDump].IndexWashedContent) As IndexWashedContent, dbo.[Venexus_BrainDump].ModuleID As ModuleID, dbo.[Venexus_BrainDump].TabID As TabID, dbo.[Venexus_BrainDump].FileID As FileID, dbo.[Venexus_BrainDump].IndexSummary, dbo.[Venexus_BrainDump].CategoryID FROM dbo.[Venexus_BrainDump] INNER JOIN @Results R ON dbo.[Venexus_BrainDump].IndexID = R.[Key] WHERE dbo.[Venexus_BrainDump].PortalID = @PortalID AND dbo.[Venexus_BrainDump].IsApproved = 1 AND dbo.[Venexus_BrainDump].IsDeleted = 0 ORDER BY R.Rank DESC GO
The ISP says the FULL TEXT has been enabled. I cannot confirm or deny that fact. I did, however, click on the 'Ensure Full Text is enabled' button that you provided in the modules settings and it said yes (or something to that affect).
I will not proceed with the procedure you gave me. |
|
|
|
|
mmcintyre@ormac.com
Posts:8
Send A Message
 |
| 05/08/2008 12:33 PM |
|
Step 1: sp_fulltext_database 'enable'
(1 row(s) affected)
(0 row(s) affected)
(1 row(s) affected)
Step 2: EXEC sp_fulltext_catalog 'VenexusSearchCatalog', 'drop'
Command(s) completed successfully.
Step 3: EXEC sp_fulltext_catalog 'VenexusSearchCatalog', 'create'
Command(s) completed successfully.
Step 4: Create Unique Index PKVenexusSearchEngine On [Venexus_BrainDump](IndexID)
There is already an index on table 'Venexus_BrainDump' named 'PKVenexusSearchEngine'
It is running on SQL Server 2000:
Step 5. EXEC sp_fulltext_column '[Venexus_BrainDump]', 'IndexWashedContent', 'add'
You must first create a full-text index on table '[Venexus_BrainDump]'.
Step 6. EXEC sp_fulltext_table '[Venexus_BrainDump]', 'activate'
You must first create a full-text index on table '[Venexus_BrainDump]'.
Step 7. EXEC sp_fulltext_table '[Venexus_BrainDump]', 'start_full'
You must first create a full-text index on table '[Venexus_BrainDump]'. |
|
|
|
|
mmcintyre@ormac.com
Posts:8
Send A Message
 |
| 05/08/2008 12:35 PM |
|
BTW, I meant "I will now proceed with the procedure you gave me." NOT "I will not proceed with the procedure you gave me." as it read before. |
|
|
|
|
xfernal
Posts:76
Send A Message
 |
|
|
| You are not authorized to post a reply. |
|
|
|
|
|
|
|