I cannot get fulltext indexing to work, nor can I get any error messages to
indicate whats wrong. Here's what I did (for the pubs database)
1. From the top menu, select Tools, Full Text Indexing.
2. Click next on the opening screen.
3. On the "Select a Database" screen, choose pubs.
4. For the next screen, select "titles" as the table and click next.
5. Keep the default unique index; there is only one on the pubs table.
6. In the next screen, select Title and Notes as the fields to be indexed.
7. On the "Select a Catalog" screen, because this is the first Catalog on
the server, we are prompted for a name. In this example, "demo" is used as
the Catalog name.
8. Click next.
9. Click Finish.
10. From Enterprise Manager, expand Full-Text Catalogs
11. Right click and select "Start Full Population."
12. The catalog is now complete.
If I type sp_help_fulltext_catalogs everything looks ok.
If I type Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
I get a 1 which means ok.
If I type
SELECT title, notes FROM titles WHERE CONTAINS (notes, ' "quick easy" ')
I get 0 rows
Same if I enter
SELECT title, notes
FROM titles
--where notes like '%quick%'
WHERE CONTAINS (notes, ' quick ')
of course entering
SELECT title, notes
FROM titles
where notes like '%quick%'
gets me the record I want. Anyone have any ideas what I can check?
BTW I did this on another server and it works. The server is works is using
SQL Server developer edition. The server that doesn't work is my production
box using SQL Server standard edition
Thanks for the help.
Francis,
Shot in the dark...QUOTED IDENTIFIER setting...might check the spacing for
the item listed...might compare with CONTAINS in SQL BOL...same SP?
HTH
Jerry
"Francis" <Francis@.discussions.microsoft.com> wrote in message
news:1899D25D-7325-4501-9B55-691C7C053686@.microsoft.com...
>I cannot get fulltext indexing to work, nor can I get any error messages to
> indicate whats wrong. Here's what I did (for the pubs database)
> 1. From the top menu, select Tools, Full Text Indexing.
> 2. Click next on the opening screen.
> 3. On the "Select a Database" screen, choose pubs.
> 4. For the next screen, select "titles" as the table and click next.
> 5. Keep the default unique index; there is only one on the pubs table.
> 6. In the next screen, select Title and Notes as the fields to be
> indexed.
> 7. On the "Select a Catalog" screen, because this is the first Catalog on
> the server, we are prompted for a name. In this example, "demo" is used as
> the Catalog name.
> 8. Click next.
> 9. Click Finish.
> 10. From Enterprise Manager, expand Full-Text Catalogs
> 11. Right click and select "Start Full Population."
> 12. The catalog is now complete.
> If I type sp_help_fulltext_catalogs everything looks ok.
> If I type Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
> I get a 1 which means ok.
> If I type
> SELECT title, notes FROM titles WHERE CONTAINS (notes, ' "quick easy" ')
> I get 0 rows
> Same if I enter
>
> SELECT title, notes
> FROM titles
> --where notes like '%quick%'
> WHERE CONTAINS (notes, ' quick ')
>
> of course entering
>
> SELECT title, notes
> FROM titles
> where notes like '%quick%'
>
> gets me the record I want. Anyone have any ideas what I can check?
>
> BTW I did this on another server and it works. The server is works is
> using
> SQL Server developer edition. The server that doesn't work is my
> production
> box using SQL Server standard edition
> Thanks for the help.
>
>
>
|||Thanks Jerry. I have tried various combinations like
SELECT title, notes
FROM titles
WHERE CONTAINS (notes, 'quick')
or using double quotes with spaces in front of and behind the work quick.
I have also set up other full text indexes on this and other tables and other
databases on this server and it doesn't seem to work.
"Jerry Spivey" wrote:
> Francis,
> Shot in the dark...QUOTED IDENTIFIER setting...might check the spacing for
> the item listed...might compare with CONTAINS in SQL BOL...same SP?
> HTH
> Jerry
> "Francis" <Francis@.discussions.microsoft.com> wrote in message
> news:1899D25D-7325-4501-9B55-691C7C053686@.microsoft.com...
>
>
|||Thanks for the help. I found the problem in KB317746;
I executed the workaround described:
EXEC sp_grantlogin [NT Authority\System]
EXEC sp_addsrvrolemember @.loginame = [NT Authority\System]
, @.rolename = 'sysadmin'
and all is well now.
"Francis" wrote:
[vbcol=seagreen]
> Thanks Jerry. I have tried various combinations like
> SELECT title, notes
> FROM titles
> WHERE CONTAINS (notes, 'quick')
> or using double quotes with spaces in front of and behind the work quick.
> I have also set up other full text indexes on this and other tables and other
> databases on this server and it doesn't seem to work.
>
> "Jerry Spivey" wrote:
2012年3月19日星期一
Full Text not working
I cannot get fulltext indexing to work, nor can I get any error messages to
indicate whats wrong. Here's what I did (for the pubs database)
1. From the top menu, select Tools, Full Text Indexing.
2. Click next on the opening screen.
3. On the "Select a Database" screen, choose pubs.
4. For the next screen, select "titles" as the table and click next.
5. Keep the default unique index; there is only one on the pubs table.
6. In the next screen, select Title and Notes as the fields to be indexed.
7. On the "Select a Catalog" screen, because this is the first Catalog on
the server, we are prompted for a name. In this example, "demo" is used as
the Catalog name.
8. Click next.
9. Click Finish.
10. From Enterprise Manager, expand Full-Text Catalogs
11. Right click and select "Start Full Population."
12. The catalog is now complete.
If I type sp_help_fulltext_catalogs everything looks ok.
If I type Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
I get a 1 which means ok.
If I type
SELECT title, notes FROM titles WHERE CONTAINS (notes, ' "quick easy" ')
I get 0 rows
Same if I enter
SELECT title, notes
FROM titles
--where notes like '%quick%'
WHERE CONTAINS (notes, ' quick ')
of course entering
SELECT title, notes
FROM titles
where notes like '%quick%'
gets me the record I want. Anyone have any ideas what I can check?
BTW I did this on another server and it works. The server is works is using
SQL Server developer edition. The server that doesn't work is my production
box using SQL Server standard edition
Thanks for the help.Francis,
Shot in the dark...QUOTED IDENTIFIER setting...might check the spacing for
the item listed...might compare with CONTAINS in SQL BOL...same SP?
HTH
Jerry
"Francis" <Francis@.discussions.microsoft.com> wrote in message
news:1899D25D-7325-4501-9B55-691C7C053686@.microsoft.com...
>I cannot get fulltext indexing to work, nor can I get any error messages to
> indicate whats wrong. Here's what I did (for the pubs database)
> 1. From the top menu, select Tools, Full Text Indexing.
> 2. Click next on the opening screen.
> 3. On the "Select a Database" screen, choose pubs.
> 4. For the next screen, select "titles" as the table and click next.
> 5. Keep the default unique index; there is only one on the pubs table.
> 6. In the next screen, select Title and Notes as the fields to be
> indexed.
> 7. On the "Select a Catalog" screen, because this is the first Catalog on
> the server, we are prompted for a name. In this example, "demo" is used as
> the Catalog name.
> 8. Click next.
> 9. Click Finish.
> 10. From Enterprise Manager, expand Full-Text Catalogs
> 11. Right click and select "Start Full Population."
> 12. The catalog is now complete.
> If I type sp_help_fulltext_catalogs everything looks ok.
> If I type Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
> I get a 1 which means ok.
> If I type
> SELECT title, notes FROM titles WHERE CONTAINS (notes, ' "quick easy" ')
> I get 0 rows
> Same if I enter
>
> SELECT title, notes
> FROM titles
> --where notes like '%quick%'
> WHERE CONTAINS (notes, ' quick ')
>
> of course entering
>
> SELECT title, notes
> FROM titles
> where notes like '%quick%'
>
> gets me the record I want. Anyone have any ideas what I can check?
>
> BTW I did this on another server and it works. The server is works is
> using
> SQL Server developer edition. The server that doesn't work is my
> production
> box using SQL Server standard edition
> Thanks for the help.
>
>
>|||Thanks Jerry. I have tried various combinations like
SELECT title, notes
FROM titles
WHERE CONTAINS (notes, 'quick')
or using double quotes with spaces in front of and behind the work quick.
I have also set up other full text indexes on this and other tables and othe
r
databases on this server and it doesn't seem to work.
"Jerry Spivey" wrote:
> Francis,
> Shot in the dark...QUOTED IDENTIFIER setting...might check the spacing for
> the item listed...might compare with CONTAINS in SQL BOL...same SP?
> HTH
> Jerry
> "Francis" <Francis@.discussions.microsoft.com> wrote in message
> news:1899D25D-7325-4501-9B55-691C7C053686@.microsoft.com...
>
>|||Thanks for the help. I found the problem in KB317746;
I executed the workaround described:
EXEC sp_grantlogin [NT Authority\System]
EXEC sp_addsrvrolemember @.loginame = [NT Authority\System]
, @.rolename = 'sysadmin'
and all is well now.
"Francis" wrote:
[vbcol=seagreen]
> Thanks Jerry. I have tried various combinations like
> SELECT title, notes
> FROM titles
> WHERE CONTAINS (notes, 'quick')
> or using double quotes with spaces in front of and behind the work quick.
> I have also set up other full text indexes on this and other tables and ot
her
> databases on this server and it doesn't seem to work.
>
> "Jerry Spivey" wrote:
>
indicate whats wrong. Here's what I did (for the pubs database)
1. From the top menu, select Tools, Full Text Indexing.
2. Click next on the opening screen.
3. On the "Select a Database" screen, choose pubs.
4. For the next screen, select "titles" as the table and click next.
5. Keep the default unique index; there is only one on the pubs table.
6. In the next screen, select Title and Notes as the fields to be indexed.
7. On the "Select a Catalog" screen, because this is the first Catalog on
the server, we are prompted for a name. In this example, "demo" is used as
the Catalog name.
8. Click next.
9. Click Finish.
10. From Enterprise Manager, expand Full-Text Catalogs
11. Right click and select "Start Full Population."
12. The catalog is now complete.
If I type sp_help_fulltext_catalogs everything looks ok.
If I type Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
I get a 1 which means ok.
If I type
SELECT title, notes FROM titles WHERE CONTAINS (notes, ' "quick easy" ')
I get 0 rows
Same if I enter
SELECT title, notes
FROM titles
--where notes like '%quick%'
WHERE CONTAINS (notes, ' quick ')
of course entering
SELECT title, notes
FROM titles
where notes like '%quick%'
gets me the record I want. Anyone have any ideas what I can check?
BTW I did this on another server and it works. The server is works is using
SQL Server developer edition. The server that doesn't work is my production
box using SQL Server standard edition
Thanks for the help.Francis,
Shot in the dark...QUOTED IDENTIFIER setting...might check the spacing for
the item listed...might compare with CONTAINS in SQL BOL...same SP?
HTH
Jerry
"Francis" <Francis@.discussions.microsoft.com> wrote in message
news:1899D25D-7325-4501-9B55-691C7C053686@.microsoft.com...
>I cannot get fulltext indexing to work, nor can I get any error messages to
> indicate whats wrong. Here's what I did (for the pubs database)
> 1. From the top menu, select Tools, Full Text Indexing.
> 2. Click next on the opening screen.
> 3. On the "Select a Database" screen, choose pubs.
> 4. For the next screen, select "titles" as the table and click next.
> 5. Keep the default unique index; there is only one on the pubs table.
> 6. In the next screen, select Title and Notes as the fields to be
> indexed.
> 7. On the "Select a Catalog" screen, because this is the first Catalog on
> the server, we are prompted for a name. In this example, "demo" is used as
> the Catalog name.
> 8. Click next.
> 9. Click Finish.
> 10. From Enterprise Manager, expand Full-Text Catalogs
> 11. Right click and select "Start Full Population."
> 12. The catalog is now complete.
> If I type sp_help_fulltext_catalogs everything looks ok.
> If I type Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
> I get a 1 which means ok.
> If I type
> SELECT title, notes FROM titles WHERE CONTAINS (notes, ' "quick easy" ')
> I get 0 rows
> Same if I enter
>
> SELECT title, notes
> FROM titles
> --where notes like '%quick%'
> WHERE CONTAINS (notes, ' quick ')
>
> of course entering
>
> SELECT title, notes
> FROM titles
> where notes like '%quick%'
>
> gets me the record I want. Anyone have any ideas what I can check?
>
> BTW I did this on another server and it works. The server is works is
> using
> SQL Server developer edition. The server that doesn't work is my
> production
> box using SQL Server standard edition
> Thanks for the help.
>
>
>|||Thanks Jerry. I have tried various combinations like
SELECT title, notes
FROM titles
WHERE CONTAINS (notes, 'quick')
or using double quotes with spaces in front of and behind the work quick.
I have also set up other full text indexes on this and other tables and othe
r
databases on this server and it doesn't seem to work.
"Jerry Spivey" wrote:
> Francis,
> Shot in the dark...QUOTED IDENTIFIER setting...might check the spacing for
> the item listed...might compare with CONTAINS in SQL BOL...same SP?
> HTH
> Jerry
> "Francis" <Francis@.discussions.microsoft.com> wrote in message
> news:1899D25D-7325-4501-9B55-691C7C053686@.microsoft.com...
>
>|||Thanks for the help. I found the problem in KB317746;
I executed the workaround described:
EXEC sp_grantlogin [NT Authority\System]
EXEC sp_addsrvrolemember @.loginame = [NT Authority\System]
, @.rolename = 'sysadmin'
and all is well now.
"Francis" wrote:
[vbcol=seagreen]
> Thanks Jerry. I have tried various combinations like
> SELECT title, notes
> FROM titles
> WHERE CONTAINS (notes, 'quick')
> or using double quotes with spaces in front of and behind the work quick.
> I have also set up other full text indexes on this and other tables and ot
her
> databases on this server and it doesn't seem to work.
>
> "Jerry Spivey" wrote:
>
Full Text not working
I cannot get fulltext indexing to work, nor can I get any error messages to
indicate whats wrong. Here's what I did (for the pubs database)
1. From the top menu, select Tools, Full Text Indexing.
2. Click next on the opening screen.
3. On the "Select a Database" screen, choose pubs.
4. For the next screen, select "titles" as the table and click next.
5. Keep the default unique index; there is only one on the pubs table.
6. In the next screen, select Title and Notes as the fields to be indexed.
7. On the "Select a Catalog" screen, because this is the first Catalog on
the server, we are prompted for a name. In this example, "demo" is used as
the Catalog name.
8. Click next.
9. Click Finish.
10. From Enterprise Manager, expand Full-Text Catalogs
11. Right click and select "Start Full Population."
12. The catalog is now complete.
If I type sp_help_fulltext_catalogs everything looks ok.
If I type Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
I get a 1 which means ok.
If I type
SELECT title, notes FROM titles WHERE CONTAINS (notes, ' "quick easy" ')
I get 0 rows
Same if I enter
SELECT title, notes
FROM titles
--where notes like '%quick%'
WHERE CONTAINS (notes, ' quick ')
of course entering
SELECT title, notes
FROM titles
where notes like '%quick%'
gets me the record I want. Anyone have any ideas what I can check?
BTW I did this on another server and it works. The server is works is using
SQL Server developer edition. The server that doesn't work is my production
box using SQL Server standard edition
Thanks for the help.Francis,
Shot in the dark...QUOTED IDENTIFIER setting...might check the spacing for
the item listed...might compare with CONTAINS in SQL BOL...same SP?
HTH
Jerry
"Francis" <Francis@.discussions.microsoft.com> wrote in message
news:1899D25D-7325-4501-9B55-691C7C053686@.microsoft.com...
>I cannot get fulltext indexing to work, nor can I get any error messages to
> indicate whats wrong. Here's what I did (for the pubs database)
> 1. From the top menu, select Tools, Full Text Indexing.
> 2. Click next on the opening screen.
> 3. On the "Select a Database" screen, choose pubs.
> 4. For the next screen, select "titles" as the table and click next.
> 5. Keep the default unique index; there is only one on the pubs table.
> 6. In the next screen, select Title and Notes as the fields to be
> indexed.
> 7. On the "Select a Catalog" screen, because this is the first Catalog on
> the server, we are prompted for a name. In this example, "demo" is used as
> the Catalog name.
> 8. Click next.
> 9. Click Finish.
> 10. From Enterprise Manager, expand Full-Text Catalogs
> 11. Right click and select "Start Full Population."
> 12. The catalog is now complete.
> If I type sp_help_fulltext_catalogs everything looks ok.
> If I type Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
> I get a 1 which means ok.
> If I type
> SELECT title, notes FROM titles WHERE CONTAINS (notes, ' "quick easy" ')
> I get 0 rows
> Same if I enter
>
> SELECT title, notes
> FROM titles
> --where notes like '%quick%'
> WHERE CONTAINS (notes, ' quick ')
>
> of course entering
>
> SELECT title, notes
> FROM titles
> where notes like '%quick%'
>
> gets me the record I want. Anyone have any ideas what I can check?
>
> BTW I did this on another server and it works. The server is works is
> using
> SQL Server developer edition. The server that doesn't work is my
> production
> box using SQL Server standard edition
> Thanks for the help.
>
>
>|||Thanks Jerry. I have tried various combinations like
SELECT title, notes
FROM titles
WHERE CONTAINS (notes, 'quick')
or using double quotes with spaces in front of and behind the work quick.
I have also set up other full text indexes on this and other tables and other
databases on this server and it doesn't seem to work.
"Jerry Spivey" wrote:
> Francis,
> Shot in the dark...QUOTED IDENTIFIER setting...might check the spacing for
> the item listed...might compare with CONTAINS in SQL BOL...same SP?
> HTH
> Jerry
> "Francis" <Francis@.discussions.microsoft.com> wrote in message
> news:1899D25D-7325-4501-9B55-691C7C053686@.microsoft.com...
> >I cannot get fulltext indexing to work, nor can I get any error messages to
> > indicate whats wrong. Here's what I did (for the pubs database)
> >
> > 1. From the top menu, select Tools, Full Text Indexing.
> >
> > 2. Click next on the opening screen.
> >
> > 3. On the "Select a Database" screen, choose pubs.
> >
> > 4. For the next screen, select "titles" as the table and click next.
> >
> > 5. Keep the default unique index; there is only one on the pubs table.
> >
> > 6. In the next screen, select Title and Notes as the fields to be
> > indexed.
> >
> > 7. On the "Select a Catalog" screen, because this is the first Catalog on
> > the server, we are prompted for a name. In this example, "demo" is used as
> > the Catalog name.
> >
> > 8. Click next.
> >
> > 9. Click Finish.
> >
> > 10. From Enterprise Manager, expand Full-Text Catalogs
> >
> > 11. Right click and select "Start Full Population."
> >
> > 12. The catalog is now complete.
> >
> > If I type sp_help_fulltext_catalogs everything looks ok.
> >
> > If I type Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
> > I get a 1 which means ok.
> >
> > If I type
> >
> > SELECT title, notes FROM titles WHERE CONTAINS (notes, ' "quick easy" ')
> > I get 0 rows
> >
> > Same if I enter
> >
> >
> > SELECT title, notes
> > FROM titles
> > --where notes like '%quick%'
> > WHERE CONTAINS (notes, ' quick ')
> >
> >
> >
> > of course entering
> >
> >
> > SELECT title, notes
> > FROM titles
> > where notes like '%quick%'
> >
> >
> >
> > gets me the record I want. Anyone have any ideas what I can check?
> >
> >
> > BTW I did this on another server and it works. The server is works is
> > using
> > SQL Server developer edition. The server that doesn't work is my
> > production
> > box using SQL Server standard edition
> >
> > Thanks for the help.
> >
> >
> >
> >
> >
>
>|||Thanks for the help. I found the problem in KB317746;
I executed the workaround described:
EXEC sp_grantlogin [NT Authority\System]
EXEC sp_addsrvrolemember @.loginame = [NT Authority\System]
, @.rolename = 'sysadmin'
and all is well now.
"Francis" wrote:
> Thanks Jerry. I have tried various combinations like
> SELECT title, notes
> FROM titles
> WHERE CONTAINS (notes, 'quick')
> or using double quotes with spaces in front of and behind the work quick.
> I have also set up other full text indexes on this and other tables and other
> databases on this server and it doesn't seem to work.
>
> "Jerry Spivey" wrote:
> > Francis,
> >
> > Shot in the dark...QUOTED IDENTIFIER setting...might check the spacing for
> > the item listed...might compare with CONTAINS in SQL BOL...same SP?
> >
> > HTH
> >
> > Jerry
> > "Francis" <Francis@.discussions.microsoft.com> wrote in message
> > news:1899D25D-7325-4501-9B55-691C7C053686@.microsoft.com...
> > >I cannot get fulltext indexing to work, nor can I get any error messages to
> > > indicate whats wrong. Here's what I did (for the pubs database)
> > >
> > > 1. From the top menu, select Tools, Full Text Indexing.
> > >
> > > 2. Click next on the opening screen.
> > >
> > > 3. On the "Select a Database" screen, choose pubs.
> > >
> > > 4. For the next screen, select "titles" as the table and click next.
> > >
> > > 5. Keep the default unique index; there is only one on the pubs table.
> > >
> > > 6. In the next screen, select Title and Notes as the fields to be
> > > indexed.
> > >
> > > 7. On the "Select a Catalog" screen, because this is the first Catalog on
> > > the server, we are prompted for a name. In this example, "demo" is used as
> > > the Catalog name.
> > >
> > > 8. Click next.
> > >
> > > 9. Click Finish.
> > >
> > > 10. From Enterprise Manager, expand Full-Text Catalogs
> > >
> > > 11. Right click and select "Start Full Population."
> > >
> > > 12. The catalog is now complete.
> > >
> > > If I type sp_help_fulltext_catalogs everything looks ok.
> > >
> > > If I type Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
> > > I get a 1 which means ok.
> > >
> > > If I type
> > >
> > > SELECT title, notes FROM titles WHERE CONTAINS (notes, ' "quick easy" ')
> > > I get 0 rows
> > >
> > > Same if I enter
> > >
> > >
> > > SELECT title, notes
> > > FROM titles
> > > --where notes like '%quick%'
> > > WHERE CONTAINS (notes, ' quick ')
> > >
> > >
> > >
> > > of course entering
> > >
> > >
> > > SELECT title, notes
> > > FROM titles
> > > where notes like '%quick%'
> > >
> > >
> > >
> > > gets me the record I want. Anyone have any ideas what I can check?
> > >
> > >
> > > BTW I did this on another server and it works. The server is works is
> > > using
> > > SQL Server developer edition. The server that doesn't work is my
> > > production
> > > box using SQL Server standard edition
> > >
> > > Thanks for the help.
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
indicate whats wrong. Here's what I did (for the pubs database)
1. From the top menu, select Tools, Full Text Indexing.
2. Click next on the opening screen.
3. On the "Select a Database" screen, choose pubs.
4. For the next screen, select "titles" as the table and click next.
5. Keep the default unique index; there is only one on the pubs table.
6. In the next screen, select Title and Notes as the fields to be indexed.
7. On the "Select a Catalog" screen, because this is the first Catalog on
the server, we are prompted for a name. In this example, "demo" is used as
the Catalog name.
8. Click next.
9. Click Finish.
10. From Enterprise Manager, expand Full-Text Catalogs
11. Right click and select "Start Full Population."
12. The catalog is now complete.
If I type sp_help_fulltext_catalogs everything looks ok.
If I type Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
I get a 1 which means ok.
If I type
SELECT title, notes FROM titles WHERE CONTAINS (notes, ' "quick easy" ')
I get 0 rows
Same if I enter
SELECT title, notes
FROM titles
--where notes like '%quick%'
WHERE CONTAINS (notes, ' quick ')
of course entering
SELECT title, notes
FROM titles
where notes like '%quick%'
gets me the record I want. Anyone have any ideas what I can check?
BTW I did this on another server and it works. The server is works is using
SQL Server developer edition. The server that doesn't work is my production
box using SQL Server standard edition
Thanks for the help.Francis,
Shot in the dark...QUOTED IDENTIFIER setting...might check the spacing for
the item listed...might compare with CONTAINS in SQL BOL...same SP?
HTH
Jerry
"Francis" <Francis@.discussions.microsoft.com> wrote in message
news:1899D25D-7325-4501-9B55-691C7C053686@.microsoft.com...
>I cannot get fulltext indexing to work, nor can I get any error messages to
> indicate whats wrong. Here's what I did (for the pubs database)
> 1. From the top menu, select Tools, Full Text Indexing.
> 2. Click next on the opening screen.
> 3. On the "Select a Database" screen, choose pubs.
> 4. For the next screen, select "titles" as the table and click next.
> 5. Keep the default unique index; there is only one on the pubs table.
> 6. In the next screen, select Title and Notes as the fields to be
> indexed.
> 7. On the "Select a Catalog" screen, because this is the first Catalog on
> the server, we are prompted for a name. In this example, "demo" is used as
> the Catalog name.
> 8. Click next.
> 9. Click Finish.
> 10. From Enterprise Manager, expand Full-Text Catalogs
> 11. Right click and select "Start Full Population."
> 12. The catalog is now complete.
> If I type sp_help_fulltext_catalogs everything looks ok.
> If I type Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
> I get a 1 which means ok.
> If I type
> SELECT title, notes FROM titles WHERE CONTAINS (notes, ' "quick easy" ')
> I get 0 rows
> Same if I enter
>
> SELECT title, notes
> FROM titles
> --where notes like '%quick%'
> WHERE CONTAINS (notes, ' quick ')
>
> of course entering
>
> SELECT title, notes
> FROM titles
> where notes like '%quick%'
>
> gets me the record I want. Anyone have any ideas what I can check?
>
> BTW I did this on another server and it works. The server is works is
> using
> SQL Server developer edition. The server that doesn't work is my
> production
> box using SQL Server standard edition
> Thanks for the help.
>
>
>|||Thanks Jerry. I have tried various combinations like
SELECT title, notes
FROM titles
WHERE CONTAINS (notes, 'quick')
or using double quotes with spaces in front of and behind the work quick.
I have also set up other full text indexes on this and other tables and other
databases on this server and it doesn't seem to work.
"Jerry Spivey" wrote:
> Francis,
> Shot in the dark...QUOTED IDENTIFIER setting...might check the spacing for
> the item listed...might compare with CONTAINS in SQL BOL...same SP?
> HTH
> Jerry
> "Francis" <Francis@.discussions.microsoft.com> wrote in message
> news:1899D25D-7325-4501-9B55-691C7C053686@.microsoft.com...
> >I cannot get fulltext indexing to work, nor can I get any error messages to
> > indicate whats wrong. Here's what I did (for the pubs database)
> >
> > 1. From the top menu, select Tools, Full Text Indexing.
> >
> > 2. Click next on the opening screen.
> >
> > 3. On the "Select a Database" screen, choose pubs.
> >
> > 4. For the next screen, select "titles" as the table and click next.
> >
> > 5. Keep the default unique index; there is only one on the pubs table.
> >
> > 6. In the next screen, select Title and Notes as the fields to be
> > indexed.
> >
> > 7. On the "Select a Catalog" screen, because this is the first Catalog on
> > the server, we are prompted for a name. In this example, "demo" is used as
> > the Catalog name.
> >
> > 8. Click next.
> >
> > 9. Click Finish.
> >
> > 10. From Enterprise Manager, expand Full-Text Catalogs
> >
> > 11. Right click and select "Start Full Population."
> >
> > 12. The catalog is now complete.
> >
> > If I type sp_help_fulltext_catalogs everything looks ok.
> >
> > If I type Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
> > I get a 1 which means ok.
> >
> > If I type
> >
> > SELECT title, notes FROM titles WHERE CONTAINS (notes, ' "quick easy" ')
> > I get 0 rows
> >
> > Same if I enter
> >
> >
> > SELECT title, notes
> > FROM titles
> > --where notes like '%quick%'
> > WHERE CONTAINS (notes, ' quick ')
> >
> >
> >
> > of course entering
> >
> >
> > SELECT title, notes
> > FROM titles
> > where notes like '%quick%'
> >
> >
> >
> > gets me the record I want. Anyone have any ideas what I can check?
> >
> >
> > BTW I did this on another server and it works. The server is works is
> > using
> > SQL Server developer edition. The server that doesn't work is my
> > production
> > box using SQL Server standard edition
> >
> > Thanks for the help.
> >
> >
> >
> >
> >
>
>|||Thanks for the help. I found the problem in KB317746;
I executed the workaround described:
EXEC sp_grantlogin [NT Authority\System]
EXEC sp_addsrvrolemember @.loginame = [NT Authority\System]
, @.rolename = 'sysadmin'
and all is well now.
"Francis" wrote:
> Thanks Jerry. I have tried various combinations like
> SELECT title, notes
> FROM titles
> WHERE CONTAINS (notes, 'quick')
> or using double quotes with spaces in front of and behind the work quick.
> I have also set up other full text indexes on this and other tables and other
> databases on this server and it doesn't seem to work.
>
> "Jerry Spivey" wrote:
> > Francis,
> >
> > Shot in the dark...QUOTED IDENTIFIER setting...might check the spacing for
> > the item listed...might compare with CONTAINS in SQL BOL...same SP?
> >
> > HTH
> >
> > Jerry
> > "Francis" <Francis@.discussions.microsoft.com> wrote in message
> > news:1899D25D-7325-4501-9B55-691C7C053686@.microsoft.com...
> > >I cannot get fulltext indexing to work, nor can I get any error messages to
> > > indicate whats wrong. Here's what I did (for the pubs database)
> > >
> > > 1. From the top menu, select Tools, Full Text Indexing.
> > >
> > > 2. Click next on the opening screen.
> > >
> > > 3. On the "Select a Database" screen, choose pubs.
> > >
> > > 4. For the next screen, select "titles" as the table and click next.
> > >
> > > 5. Keep the default unique index; there is only one on the pubs table.
> > >
> > > 6. In the next screen, select Title and Notes as the fields to be
> > > indexed.
> > >
> > > 7. On the "Select a Catalog" screen, because this is the first Catalog on
> > > the server, we are prompted for a name. In this example, "demo" is used as
> > > the Catalog name.
> > >
> > > 8. Click next.
> > >
> > > 9. Click Finish.
> > >
> > > 10. From Enterprise Manager, expand Full-Text Catalogs
> > >
> > > 11. Right click and select "Start Full Population."
> > >
> > > 12. The catalog is now complete.
> > >
> > > If I type sp_help_fulltext_catalogs everything looks ok.
> > >
> > > If I type Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
> > > I get a 1 which means ok.
> > >
> > > If I type
> > >
> > > SELECT title, notes FROM titles WHERE CONTAINS (notes, ' "quick easy" ')
> > > I get 0 rows
> > >
> > > Same if I enter
> > >
> > >
> > > SELECT title, notes
> > > FROM titles
> > > --where notes like '%quick%'
> > > WHERE CONTAINS (notes, ' quick ')
> > >
> > >
> > >
> > > of course entering
> > >
> > >
> > > SELECT title, notes
> > > FROM titles
> > > where notes like '%quick%'
> > >
> > >
> > >
> > > gets me the record I want. Anyone have any ideas what I can check?
> > >
> > >
> > > BTW I did this on another server and it works. The server is works is
> > > using
> > > SQL Server developer edition. The server that doesn't work is my
> > > production
> > > box using SQL Server standard edition
> > >
> > > Thanks for the help.
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
2012年2月26日星期日
Full Justify Doesn't Work - RS 2005
The RS2005 full justification icon seems to be grayed out and doesn't
work on textboxes.
Nor is there a Full Justification choice for the TextAlign property.
Is there a way to fully justify a textbox on both right and left edges?
Or any third-party rich-text controls that could be used on reports to
accomplish full justification?
I already have a column in database with RTF-coded text, as well as a plain text column.
Thanks.
Alan
Refer to my post in this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=738557&SiteID=1. It contains a walkthrough and class code that will allow you to render rich text in RTF format to an image and display that image in reporting services or wherever else you may want to embed rich text as an image. I also included pagination should it be required.Full Justify Doesn't Work - RS 2005
The RS2005 full justification icon seems to be grayed out and doesn't
work on textboxes.
Nor is there a Full Justification choice for the TextAlign property.
Is there a way to fully justify a textbox on both right and left edges?
Or any third-party rich-text controls that could be used on reports to
accomplish full justification?
I already have a column in database with RTF-coded text, as well as a plain text column.
Thanks.
Alan
Refer to my post in this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=738557&SiteID=1. It contains a walkthrough and class code that will allow you to render rich text in RTF format to an image and display that image in reporting services or wherever else you may want to embed rich text as an image. I also included pagination should it be required.
订阅：
博文 (Atom)