Funny network behaviour

Hi,

In order to establish a security enhanced SQL server setup, I tried
to switch off network access by disabling all networking protocols,
so that the server can only be reached through a pipe. Nevertheless
the server was visible in the network and could be accessed from
all clients. Does anybody know what is going on here?

GeorgGeorg Kreyerhoff wrote:
> Hi,
> In order to establish a security enhanced SQL server setup, I tried
> to switch off network access by disabling all networking protocols,
> so that the server can only be reached through a pipe. Nevertheless
> the server was visible in the network and could be accessed from
> all clients. Does anybody know what is going on here?
>
some more information on what I found out:

Even if tcp-ip and all other networking protocols are disabled in the
SQL-server configuration (only named pipes were enabled), Clients and Server
seem to be able to communicate via the Netbios-ports (Netbios-service
was still enabled on the machine). Do named pipes work over Netbios?
Or what is going on?

Georg

Full-text setup error

Hi,
I'm trying to install full-text search service on SQL server using command
ftsetup.exe, but I always get error "FulltextSetup returned error code:
0x80000023".
I've upgraded MSDE with SQL Server 2000 standard . Upgrade process did not
install full-text search service, so I had to do it manually as it is
suggested in KB article 827449
(http://support.microsoft.com/default...b;en-us;827449). I've
successfuly installed Microsoft Search service (service is running), but
when I try to configure the instance of SQL Server to use the Microsoft
Search service with ftsetup command ("ftsetup.exe SQLServer 0 1 0 0 0"), it
fails. I have SQL server 2000 standard with SP3a, and MSSQLSERVER service is
running as local system account.
Can you please give me some advice how to make full-text working?
Thanx (and Happy New Year to all),
Bogdan
Bogdan,
The procedures KB article 827449 are used when it is necessary to "manually
RE-install" the FT Search components on a server where these components were
install installed, but later determined that some problem occurred during
that installation. In your case, the initial FT Search components have not
been installed due to your upgrade path from MSDE to SQL Server 2000
Standard Edition. I'd recommend that you install the Full-text Search
components via your SQL Server 2000 Setup CD and select "custom
installation" and under "server components" you will see "Full-text Search"
and you should checkmark this and then the SQL Server 2000 Setup process
will install these components for you.
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Bogdan" <bogdan.skof@.doba.si> wrote in message
news:eTaTnon7EHA.1264@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I'm trying to install full-text search service on SQL server using command
> ftsetup.exe, but I always get error "FulltextSetup returned error code:
> 0x80000023".
> I've upgraded MSDE with SQL Server 2000 standard . Upgrade process did not
> install full-text search service, so I had to do it manually as it is
> suggested in KB article 827449
> (http://support.microsoft.com/default...b;en-us;827449). I've
> successfuly installed Microsoft Search service (service is running), but
> when I try to configure the instance of SQL Server to use the Microsoft
> Search service with ftsetup command ("ftsetup.exe SQLServer 0 1 0 0 0"),
it
> fails. I have SQL server 2000 standard with SP3a, and MSSQLSERVER service
is
> running as local system account.
> Can you please give me some advice how to make full-text working?
> Thanx (and Happy New Year to all),
> Bogdan
>

Full-Text Setup and Search

Hi,

I have a database developed using SQL Server Management Studio Express with Full-Text searching. I can go into the Object Explorer and right click on my database and choose Properties, select File and the 'Use-full-ext indexing' is checked.

I'm not sure how I create an index for a table, can someone help? I want to create an index for table 'tblLogNotes' and have the following columns:

note_id = (PK, int, not null)
note = (varchar(3000), not null)
log_id = (FK, int, not null)
operatorid = (int, not null)
note_created = (datetime, not null)

I know I did something but not sure what I did, but on one of my tables, when I right click on table and choose 'log_note', I can see that Full-text Specification = yes, (is full-text indexed = yes), full-text type column = <none> and language = English (United States).

Table 'tblLog' has the following columns:
log_id - (PK, int - not null)
log_note (varchar(3000), not null)
tag_number(varchar(50), not null)

However, when I try the following query, I get nothing:

SELECT *
FROM tblLog
WHERE CONTAINS(Log_note, '"pump*"')

I've also tried: 'pump'

What am I doing wrong?

Thanks,

Hi Ed,

You need to create a Full Text Catalog and a Full Text Index before you can query against them. See...

CREATE FULLTEXT CATALOG

CREATE FULLTEXT INDEX

and

The Full Text Overview topic in Books Online.

SSMSE does not enable the Full Text commands for technical reasons, but you can use the Template Explorer to get the basic SQL statements and then just fill in the blanks for your database.

Mike

Full-Text Search

I would like to use the Full-Text Search in MS SQL 2000, but I'm not
sure whether I can use it in my setup.
In my application the user is able to type some text (about 400
words). In the database I have a list of words that I would like to
match to the text. Is it possible to use stemming etc in this
context? Do I need to first add the text to the database and then
search for the words one by one?
Thanks in advance!
-- -- -- -
Posted with NewsLeecher v3.9 Beta 1
Web @. http://www.newsleecher.com/?usenet
-- -- -- -- -
Hello Savage,
Essentially you want to text mine your content. We do exactly as you want
by storing the text and then using looping through the keywords to search
for and store the results. We do it in a batch though, searching through
a batch of jobs at one time. This is because its not simple to do a full
text search against 1 row in a table. You could split your text into individual
words and then look for matches. There are many routines to split text but
are largely limited to one delimiter rather than a set.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> I would like to use the Full-Text Search in MS SQL 2000, but I'm not
> sure whether I can use it in my setup.
> In my application the user is able to type some text (about 400
> words). In the database I have a list of words that I would like to
> match to the text. Is it possible to use stemming etc in this context?
> Do I need to first add the text to the database and then search for
> the words one by one?
> Thanks in advance!
> --
> -- -- -- -
> Posted with NewsLeecher v3.9 Beta 1
> Web @. http://www.newsleecher.com/?usenet
> -- -- -- -- -
|||Thanks a lot for your answer. I will try to implement this!
-- -- -- -
Posted with NewsLeecher v3.9 Beta 1
Web @. http://www.newsleecher.com/?usenet
-- -- -- -- -
|||For stemming you would need to do a freetext search. Another option is to
build an inverted file index and only store and query on the root of the
word, keeping in mind handling exceptions, i.e. a search on mouse would also
return hits to mice.
Look at Porter Stemming algorithm implementations to understand how this
would work.
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
"Savage" <my@.email.com> wrote in message
news:45e947d6$0$9908$e4fe514c@.dreader25.news.xs4al l.nl...
>I would like to use the Full-Text Search in MS SQL 2000, but I'm not
> sure whether I can use it in my setup.
> In my application the user is able to type some text (about 400
> words). In the database I have a list of words that I would like to
> match to the text. Is it possible to use stemming etc in this
> context? Do I need to first add the text to the database and then
> search for the words one by one?
> Thanks in advance!
>
> --
> -- -- -- -
> Posted with NewsLeecher v3.9 Beta 1
> Web @. http://www.newsleecher.com/?usenet
> -- -- -- -- -
>
|||Thanks for your help!
-- -- -- -
Posted with NewsLeecher v3.9 Beta 1
Web @. http://www.newsleecher.com/?usenet
-- -- -- -- -