"Serkan" <serkan@insaat.org> wrote in message
news:u2t1xkesDHA.1512@TK2MSFTNGP10.phx.gbl...
> Hi all,
> I am using sql server 2000 with sp2.
>
> select @@version returns.
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001
13:23:50
> Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on
> Windows NT 5.1 (Build 2600: )
>
> I am executing the queries as sa, using query analyzer.
>
> --My first problem is I am getting this message:
> When the query must return rows it returns this error:
> Server: Msg 7342, Level 16, State 1, Procedure
> btcsp_searchpagecontents, Line 6
> Unexpected NULL value returned for column
> '[FULLTEXT:BTC_WSPAGECONTENTS].KEY' from the OLE DB provider
> 'Full-text Search Engine'. This column cannot be NULL.
> But when I query something non-sense (that never exists in my records)
> query returns an empty set not this error.
>
> --Problem 2:
> Query on another fulltext indexed table that must return some rows
> always return en empty resultset.
>
> --Not a problem, question:
> Has anyone used xp_smtp_sendmail by sqldev.net. webpage is:
> http://www.sqldev.net/xp/xpsmtp.htm
> Can I use it safely? Any ideas about its performance
>
> Thanks
> Serkan
> Thanks for
>
>

"Serkan" <serkan@insaat.org> wrote in message
news:OCEpNvfsDHA.2332@TK2MSFTNGP09.phx.gbl...
> Hi John
> > select FULLTEXTSERVICEPROPERTY('IsFulltextInstalled')
> return 1
> Microsoft search servie is also installed I am sure about it because I
> started the service myself. Because as you know if it is not running query
> return an error indicating it is not running.
> Thanks for your interest
>
> "John Kane" <jt-kane@comcast.net> wrote in message
> news:es9vbkfsDHA.3140@TK2MSFTNGP11.phx.gbl...
> > Serkan,
> > First of all, thanks for the @@version info as I can answer your
question
> > more quickly, but I will need more info from you. Note, that while SQL
> > Server 2000 Full-Text Search (FTS) is supported with SQL Server 2000
> > "Personal Edition". Specifically, see SQL Server 2000 Books Online (BOL)
> > title "Features Supported by the Editions of SQL Server 2000", the
> > "Microsoft Search" (mssearch.exe) service may not of been installed by
> > default on your WinXP machine, see BOL title "Full-Text Query
> > Architecture" -
> >
> > "While this means that the Microsoft Search service is not installed on
> > Microsoft Windows 95, Windows 98, Windows NT Workstation, or Windows
2000
> > Professional clients, these clients can make use of the service when
> > connected to an instance of SQL Server 2000 Standard Edition, SQL Server
> > 2000 Developer Edition, or SQL Server 2000 Enterprise Edition."
> >
> > Could you run the following SQL code on your WinXP machine to help
> determine
> > if MSSearch is installed ?
> >
> > select FULLTEXTSERVICEPROPERTY('IsFulltextInstalled')
> >
> > See also SQL Server 2000 BOL title "Transact-SQL full-text properties"
for
> > more details. Note, that SQL Server 2000 (Developer, Std & Enterprise
> > editions) installs the "Microsoft Search" (mssearch) service by default
> and
> > set it up to auto-start as well as run under the LocalSystem (system)
> > account.
> >
> > Regards,
> > John
> >
> >
> >
> > "Serkan" <serkan@insaat.org> wrote in message
> > news:u2t1xkesDHA.1512@TK2MSFTNGP10.phx.gbl...
> > > Hi all,
> > > I am using sql server 2000 with sp2.
> > >
> > > select @@version returns.
> > > Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001
> > 13:23:50
> > > Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on
> > > Windows NT 5.1 (Build 2600: )
> > >
> > > I am executing the queries as sa, using query analyzer.
> > >
> > > --My first problem is I am getting this message:
> > > When the query must return rows it returns this error:
> > > Server: Msg 7342, Level 16, State 1, Procedure
> > > btcsp_searchpagecontents, Line 6
> > > Unexpected NULL value returned for column
> > > '[FULLTEXT:BTC_WSPAGECONTENTS].KEY' from the OLE DB
provider
> > > 'Full-text Search Engine'. This column cannot be NULL.
> > > But when I query something non-sense (that never exists in my
> records)
> > > query returns an empty set not this error.
> > >
> > > --Problem 2:
> > > Query on another fulltext indexed table that must return some rows
> > > always return en empty resultset.
> > >
> > > --Not a problem, question:
> > > Has anyone used xp_smtp_sendmail by sqldev.net. webpage is:
> > > http://www.sqldev.net/xp/xpsmtp.htm
> > > Can I use it safely? Any ideas about its performance
> > >
> > > Thanks
> > > Serkan
> > > Thanks for
> > >
> > >
> >
> >
>
>

> select FULLTEXTSERVICEPROPERTY('IsFulltextInstalled')

"John Kane" <jt-kane@comcast.net> wrote in message
news:es9vbkfsDHA.3140@TK2MSFTNGP11.phx.gbl...
> Serkan,
> First of all, thanks for the @@version info as I can answer your question
> more quickly, but I will need more info from you. Note, that while SQL
> Server 2000 Full-Text Search (FTS) is supported with SQL Server 2000
> "Personal Edition". Specifically, see SQL Server 2000 Books Online (BOL)
> title "Features Supported by the Editions of SQL Server 2000", the
> "Microsoft Search" (mssearch.exe) service may not of been installed by
> default on your WinXP machine, see BOL title "Full-Text Query
> Architecture" -
>
> "While this means that the Microsoft Search service is not installed on
> Microsoft Windows 95, Windows 98, Windows NT Workstation, or Windows 2000
> Professional clients, these clients can make use of the service when
> connected to an instance of SQL Server 2000 Standard Edition, SQL Server
> 2000 Developer Edition, or SQL Server 2000 Enterprise Edition."
>
> Could you run the following SQL code on your WinXP machine to help
determine
> if MSSearch is installed ?
>
> select FULLTEXTSERVICEPROPERTY('IsFulltextInstalled')
>
> See also SQL Server 2000 BOL title "Transact-SQL full-text properties" for
> more details. Note, that SQL Server 2000 (Developer, Std & Enterprise
> editions) installs the "Microsoft Search" (mssearch) service by default
and
> set it up to auto-start as well as run under the LocalSystem (system)
> account.
>
> Regards,
> John
>
>
>
> "Serkan" <serkan@insaat.org> wrote in message
> news:u2t1xkesDHA.1512@TK2MSFTNGP10.phx.gbl...
> > Hi all,
> > I am using sql server 2000 with sp2.
> >
> > select @@version returns.
> > Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001
> 13:23:50
> > Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on
> > Windows NT 5.1 (Build 2600: )
> >
> > I am executing the queries as sa, using query analyzer.
> >
> > --My first problem is I am getting this message:
> > When the query must return rows it returns this error:
> > Server: Msg 7342, Level 16, State 1, Procedure
> > btcsp_searchpagecontents, Line 6
> > Unexpected NULL value returned for column
> > '[FULLTEXT:BTC_WSPAGECONTENTS].KEY' from the OLE DB provider
> > 'Full-text Search Engine'. This column cannot be NULL.
> > But when I query something non-sense (that never exists in my
records)
> > query returns an empty set not this error.
> >
> > --Problem 2:
> > Query on another fulltext indexed table that must return some rows
> > always return en empty resultset.
> >
> > --Not a problem, question:
> > Has anyone used xp_smtp_sendmail by sqldev.net. webpage is:
> > http://www.sqldev.net/xp/xpsmtp.htm
> > Can I use it safely? Any ideas about its performance
> >
> > Thanks
> > Serkan
> > Thanks for
> >
> >
>
>

"Serkan" <serkan@insaat.org> wrote in message
news:ugOEQqnsDHA.3196@TK2MSFTNGP11.phx.gbl...
> Hi again John,
> I copied schema.txt from the cd to harddrive, restarted services etc but
> nothing changed. There were 2 schema.txt on the cd one at x86\fulltext
(5kb)
> and another at x86\fulltext\mssearch\search directory(23.6kb). I tried
both
> of these files. I also tried the ones in the service pack cd but nothing
> changed :(
> I have to give up here and assume that my queries will work on a server
that
> has no such problems, can I assume that?? I have to move on as soon as
> possible but I am stuck in this problem. Can I assume that this is an
issue
> related to the configuration in my development machine and there will not
be
> a such problem in a properly configured production environment? If so I
will
> go on developing blindly and see what I've done at the production stage
:))
> Thanks for your interest
> Serkan
>
> "John Kane" <jt-kane@comcast.net> wrote in message
> news:urTu9chsDHA.2132@TK2MSFTNGP10.phx.gbl...
> > You're welcome, Serkan,
> > Ok, I just needed to confirm it... Could you confirm if the schema.txt
> that
> > is installed under <SQLPath>\FTDATA\SQLServer\Config is exactly the same
> > (size, date, content) as compared to the file that is on the CD where
you
> > installed SQL Server 2000? In the past, if this file was changed and/or
> > over-written then error Msg 7342 can occur.
> >
> > Regards,
> > John
> >
> >
> > "Serkan" <serkan@insaat.org> wrote in message
> > news:OCEpNvfsDHA.2332@TK2MSFTNGP09.phx.gbl...
> > > Hi John
> > > > select FULLTEXTSERVICEPROPERTY('IsFulltextInstalled')
> > > return 1
> > > Microsoft search servie is also installed I am sure about it because I
> > > started the service myself. Because as you know if it is not running
> query
> > > return an error indicating it is not running.
> > > Thanks for your interest
> > >
> > > "John Kane" <jt-kane@comcast.net> wrote in message
> > > news:es9vbkfsDHA.3140@TK2MSFTNGP11.phx.gbl...
> > > > Serkan,
> > > > First of all, thanks for the @@version info as I can answer your
> > question
> > > > more quickly, but I will need more info from you. Note, that while
SQL
> > > > Server 2000 Full-Text Search (FTS) is supported with SQL Server 2000
> > > > "Personal Edition". Specifically, see SQL Server 2000 Books Online
> (BOL)
> > > > title "Features Supported by the Editions of SQL Server 2000", the
> > > > "Microsoft Search" (mssearch.exe) service may not of been installed
by
> > > > default on your WinXP machine, see BOL title "Full-Text Query
> > > > Architecture" -
> > > >
> > > > "While this means that the Microsoft Search service is not installed
> on
> > > > Microsoft Windows 95, Windows 98, Windows NT Workstation, or Windows
> > 2000
> > > > Professional clients, these clients can make use of the service when
> > > > connected to an instance of SQL Server 2000 Standard Edition, SQL
> Server
> > > > 2000 Developer Edition, or SQL Server 2000 Enterprise Edition."
> > > >
> > > > Could you run the following SQL code on your WinXP machine to help
> > > determine
> > > > if MSSearch is installed ?
> > > >
> > > > select FULLTEXTSERVICEPROPERTY('IsFulltextInstalled')
> > > >
> > > > See also SQL Server 2000 BOL title "Transact-SQL full-text
properties"
> > for
> > > > more details. Note, that SQL Server 2000 (Developer, Std &
Enterprise
> > > > editions) installs the "Microsoft Search" (mssearch) service by
> default
> > > and
> > > > set it up to auto-start as well as run under the LocalSystem
(system)
> > > > account.
> > > >
> > > > Regards,
> > > > John
> > > >
> > > >
> > > >
> > > > "Serkan" <serkan@insaat.org> wrote in message
> > > > news:u2t1xkesDHA.1512@TK2MSFTNGP10.phx.gbl...
> > > > > Hi all,
> > > > > I am using sql server 2000 with sp2.
> > > > >
> > > > > select @@version returns.
> > > > > Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19
2001
> > > > 13:23:50
> > > > > Copyright (c) 1988-2000 Microsoft Corporation Personal
Edition
> on
> > > > > Windows NT 5.1 (Build 2600: )
> > > > >
> > > > > I am executing the queries as sa, using query analyzer.
> > > > >
> > > > > --My first problem is I am getting this message:
> > > > > When the query must return rows it returns this error:
> > > > > Server: Msg 7342, Level 16, State 1, Procedure
> > > > > btcsp_searchpagecontents, Line 6
> > > > > Unexpected NULL value returned for column
> > > > > '[FULLTEXT:BTC_WSPAGECONTENTS].KEY' from the OLE DB
> > provider
> > > > > 'Full-text Search Engine'. This column cannot be NULL.
> > > > > But when I query something non-sense (that never exists in my
> > > records)
> > > > > query returns an empty set not this error.
> > > > >
> > > > > --Problem 2:
> > > > > Query on another fulltext indexed table that must return some
> rows
> > > > > always return en empty resultset.
> > > > >
> > > > > --Not a problem, question:
> > > > > Has anyone used xp_smtp_sendmail by sqldev.net. webpage is:
> > > > > http://www.sqldev.net/xp/xpsmtp.htm
> > > > > Can I use it safely? Any ideas about its performance
> > > > >
> > > > > Thanks
> > > > > Serkan
> > > > > Thanks for
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

"Serkan" <serkan@insaat.org> wrote in message
news:OF6xfUrsDHA.3532@TK2MSFTNGP11.phx.gbl...
> Hi
> I will try to solve the problem as much as I can, thanks for all.
> And one last question:
> I have queries that does not return error but return empty result set.
> The table used in this query is different and this does not the mentioned
> error.
> For ex:
> a query like:" SELECT X from Table WHERE field LIKE '%serkan%' "
> returns two rows
> but
> a query like:" SELECT X from Table WHERE CONTAINS(*,'"serkan"' ) "
> returns no rows
> (field is fulltext indexed of course)
>
> Can this be related to the other problem?
>
> Serkan
>
>

"John Kane" <jt-kane@comcast.net> wrote in message
news:urTu9chsDHA.2132@TK2MSFTNGP10.phx.gbl...
> You're welcome, Serkan,
> Ok, I just needed to confirm it... Could you confirm if the schema.txt
that
> is installed under <SQLPath>\FTDATA\SQLServer\Config is exactly the same
> (size, date, content) as compared to the file that is on the CD where you
> installed SQL Server 2000? In the past, if this file was changed and/or
> over-written then error Msg 7342 can occur.
>
> Regards,
> John
>
>
> "Serkan" <serkan@insaat.org> wrote in message
> news:OCEpNvfsDHA.2332@TK2MSFTNGP09.phx.gbl...
> > Hi John
> > > select FULLTEXTSERVICEPROPERTY('IsFulltextInstalled')
> > return 1
> > Microsoft search servie is also installed I am sure about it because I
> > started the service myself. Because as you know if it is not running
query
> > return an error indicating it is not running.
> > Thanks for your interest
> >
> > "John Kane" <jt-kane@comcast.net> wrote in message
> > news:es9vbkfsDHA.3140@TK2MSFTNGP11.phx.gbl...
> > > Serkan,
> > > First of all, thanks for the @@version info as I can answer your
> question
> > > more quickly, but I will need more info from you. Note, that while SQL
> > > Server 2000 Full-Text Search (FTS) is supported with SQL Server 2000
> > > "Personal Edition". Specifically, see SQL Server 2000 Books Online
(BOL)
> > > title "Features Supported by the Editions of SQL Server 2000", the
> > > "Microsoft Search" (mssearch.exe) service may not of been installed by
> > > default on your WinXP machine, see BOL title "Full-Text Query
> > > Architecture" -
> > >
> > > "While this means that the Microsoft Search service is not installed
on
> > > Microsoft Windows 95, Windows 98, Windows NT Workstation, or Windows
> 2000
> > > Professional clients, these clients can make use of the service when
> > > connected to an instance of SQL Server 2000 Standard Edition, SQL
Server
> > > 2000 Developer Edition, or SQL Server 2000 Enterprise Edition."
> > >
> > > Could you run the following SQL code on your WinXP machine to help
> > determine
> > > if MSSearch is installed ?
> > >
> > > select FULLTEXTSERVICEPROPERTY('IsFulltextInstalled')
> > >
> > > See also SQL Server 2000 BOL title "Transact-SQL full-text properties"
> for
> > > more details. Note, that SQL Server 2000 (Developer, Std & Enterprise
> > > editions) installs the "Microsoft Search" (mssearch) service by
default
> > and
> > > set it up to auto-start as well as run under the LocalSystem (system)
> > > account.
> > >
> > > Regards,
> > > John
> > >
> > >
> > >
> > > "Serkan" <serkan@insaat.org> wrote in message
> > > news:u2t1xkesDHA.1512@TK2MSFTNGP10.phx.gbl...
> > > > Hi all,
> > > > I am using sql server 2000 with sp2.
> > > >
> > > > select @@version returns.
> > > > Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001
> > > 13:23:50
> > > > Copyright (c) 1988-2000 Microsoft Corporation Personal Edition
on
> > > > Windows NT 5.1 (Build 2600: )
> > > >
> > > > I am executing the queries as sa, using query analyzer.
> > > >
> > > > --My first problem is I am getting this message:
> > > > When the query must return rows it returns this error:
> > > > Server: Msg 7342, Level 16, State 1, Procedure
> > > > btcsp_searchpagecontents, Line 6
> > > > Unexpected NULL value returned for column
> > > > '[FULLTEXT:BTC_WSPAGECONTENTS].KEY' from the OLE DB
> provider
> > > > 'Full-text Search Engine'. This column cannot be NULL.
> > > > But when I query something non-sense (that never exists in my
> > records)
> > > > query returns an empty set not this error.
> > > >
> > > > --Problem 2:
> > > > Query on another fulltext indexed table that must return some
rows
> > > > always return en empty resultset.
> > > >
> > > > --Not a problem, question:
> > > > Has anyone used xp_smtp_sendmail by sqldev.net. webpage is:
> > > > http://www.sqldev.net/xp/xpsmtp.htm
> > > > Can I use it safely? Any ideas about its performance
> > > >
> > > > Thanks
> > > > Serkan
> > > > Thanks for
> > > >
> > > >
> > >
> > >
> >
> >
>
>