Problem with Index Tuning Wizard

When running the Index Tuning Wizard (ITW) on our SQL Server we got a
error message : 'Could not complete cursor operation because the table
schema changed after the cursor was declared'
The ITW was used only to advice new indexes. I know that it creates
hypothetical indexes in the sysindexes table, but what are the changes
in the user-tables ?
How do you use the ITW without interfering with the real
schema-definitions ?
thanks,
RobbertHi,
Before using the ITW, you should get a load of the queries
you are running. You can capture the events in profiler
and then use that load file for the ITW to use.
hth
DeeJay
>--Original Message--
>When running the Index Tuning Wizard (ITW) on our SQL
Server we got a
>error message : 'Could not complete cursor operation
because the table
>schema changed after the cursor was declared'
>The ITW was used only to advice new indexes. I know that
it creates
>hypothetical indexes in the sysindexes table, but what
are the changes
>in the user-tables ?
>How do you use the ITW without interfering with the real
>schema-definitions ?
>thanks,
>Robbert
>.
>|||My theory on this is while you were running the ITW
someone in your tream made a change to the structure a
table, which caused it to get an error.
I have run ITW a number of times using our Production
Database, with no problems.
Peter
"We are all worms. But I believe that I am a glow-worm."
Winston Churchill
>--Original Message--
>When running the Index Tuning Wizard (ITW) on our SQL
Server we got a
>error message : 'Could not complete cursor operation
because the table
>schema changed after the cursor was declared'
>The ITW was used only to advice new indexes. I know that
it creates
>hypothetical indexes in the sysindexes table, but what
are the changes
>in the user-tables ?
>How do you use the ITW without interfering with the real
>schema-definitions ?
>thanks,
>Robbert
>.
>

Problem with Full-text searching

I am getting this error message from SQL Server when attempting any full-text
catalog operation:
Error 7619: Execution of a full-text operation failed. The parameter is
incorrect.
The service appears to be installed and running on Windows 2003 Server and
the error appears to be coming from stored procedures like
sp_fulltext_database. What do I need to check next to resolve this problem?
can you create your catalog or fulltext indexes through the wizard?
Hilary Cotter
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
"Andrew" <wanhelp@.elca.org> wrote in message
news:F9513F7D-D058-4AEB-BC18-321BB05896A7@.microsoft.com...
>I am getting this error message from SQL Server when attempting any
>full-text
> catalog operation:
> Error 7619: Execution of a full-text operation failed. The parameter is
> incorrect.
> The service appears to be installed and running on Windows 2003 Server and
> the error appears to be coming from stored procedures like
> sp_fulltext_database. What do I need to check next to resolve this
> problem?
>
|||"Hilary Cotter" wrote:

> can you create your catalog or fulltext indexes through the wizard?
No. The wizard terminates after this error message appears.
|||This appears to be windows 2000. Can do any operations through tsql, such as
creating a table.
Can you try this for me
create database fulltextest
GO
use fulltextest
GO
sp_fulltext_database 'enable'
GO
create table fulltext
(pk int not null identity constraint pk primary key,
charcol char (20))
GO
sp_fulltext_catalog 'test','create'
GO
sp_fulltext_table 'fulltext', 'create', 'test','pk'
GO
sp_fulltext_column 'fulltext','charcol','add'
GO
sp_fulltext_table 'fulltext','start_full'
GO
Hilary Cotter
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
"Andrew" <wanhelp@.elca.org> wrote in message
news:281B3353-53E0-48CF-85B4-559B3688217F@.microsoft.com...
> "Hilary Cotter" wrote:
>
> No. The wizard terminates after this error message appears.
>
|||"Hilary Cotter" wrote:

> This appears to be windows 2000. Can do any operations through tsql, such as
> creating a table.
> Can you try this for me
> create database fulltextest
The first step that broke was the one with sp_fulltext_database 'enable'. I
worked it out with a Microsoft support engineer, though.