I had a perfectly good FT catalog, but I was trying to repopulate it after
making changes to the noiseeng file. I restarted the Full-Text search
engine.
When I tried to run a full-text query against the table, I got this error
"no such interface supported". In the message there was a recommendation to
create a new catalog.
I decided to delete the existing catalog, but now cannot create a new one.
I get the following full message:
TITLE: Microsoft SQL Server Management Studio
Cannot execute changes.
Create failed for FullTextCatalog 'FTCDoctors'. (Microsoft.SqlServer.Smo)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Create+FullTextCatalog&LinkId=20476[/url]
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Execution of a full-text operation failed. 'No such interface supported'
(Microsoft SQL Server, Error: 7689)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .3054&EvtSrc=MSSQLServer&EvtID=7689&LinkId=20476[/url]
The links are dead links now. Figures.
Can anyone help me?
Thanks, Ross
Unable to find a cure, I uninstalled the Full-Text engine, rebooted,
reinstalled Full-Text, rebooted and was able to rebuild the catalog and
index. But I'd sure like to know what happened and what this error really
means.
Ross
"Ross Culver" <rculver@.warrenalloy.com> wrote in message
news:eOCFu7brHHA.4180@.TK2MSFTNGP04.phx.gbl...
>I had a perfectly good FT catalog, but I was trying to repopulate it after
> making changes to the noiseeng file. I restarted the Full-Text search
> engine.
> When I tried to run a full-text query against the table, I got this error
> "no such interface supported". In the message there was a recommendation
> to
> create a new catalog.
> I decided to delete the existing catalog, but now cannot create a new one.
> I get the following full message:
> TITLE: Microsoft SQL Server Management Studio
> Cannot execute changes.
> Create failed for FullTextCatalog 'FTCDoctors'. (Microsoft.SqlServer.Smo)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00. 3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo. ExceptionTemplates.FailedOperationExceptionText&Ev tID=Create+FullTextCatalog&LinkId=20476[/url]
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Execution of a full-text operation failed. 'No such interface supported'
> (Microsoft SQL Server, Error: 7689)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .3054&EvtSrc=MSSQLServer&EvtID=7689&LinkId=20476[/url]
> The links are dead links now. Figures.
> Can anyone help me?
> Thanks, Ross
>
>
No comments:
Post a Comment