Showing posts with label express. Show all posts
Showing posts with label express. Show all posts

Sunday, February 26, 2012

Full-Text-Search

Hi friends

i work with sql server 2005 express(Management Studio)

can i use full text search service with that edition of sql server?

and how i can use that.

thank u.Smile [:)]

The Full-Text Search feature is not available in SQL Server 2005 Express.

HTH,
Ryan

|||

thank u for ur answering.

so which edition of sql server support that?

|||

fahima wrote:

so which edition of sql server support that?

The Workgroup, Standard, and Enterprise editions all support Full-text Search.

HTH,
Ryan

|||

ok

is it hard to work with service?

|||

fahima wrote:

is it hard to work with service?

Do you mean is it difficult to get Full-text Search to work? I've never played with Full-text Search, but here's an article that should give you a better understanding of it:Understanding SQL Server Full-Text Indexing.

HTH,
Ryan

|||

the Express Edition does in fact have full text search feature available. to get this you need to download a different file, SQL Server with Advance services -http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

Not sure if this was released since the last post here - just though i would answer seeing as i was floating around.

regards

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 searching

Are there any plans to add full-text searching capability to SQLCE? I know it's available in SQL Server Express but it would still be useful for an embedded/desktop application -- SQLite recently added this.We have this feature on our radar, but time lines for this have not been fixed yet

Full-text searching

Are there any plans to add full-text searching capability to SQLCE? I know it's available in SQL Server Express but it would still be useful for an embedded/desktop application -- SQLite recently added this.We have this feature on our radar, but time lines for this have not been fixed yet

Friday, February 24, 2012

FullText Search SQLserver2005 using VS2005 Server Explorer

Hello,

I am using SQLServer Express and Visual Studio 2005 to create the website. I would like to implement FullText search, but have never done it before. I have looked at the msdn documentation on FullText search in SQLServer 2005 herehttp://msdn2.microsoft.com/en-us/library/ms142519.aspx.

I cannot seem to figure out how to use a FT search using Visual Studio. Can someone please help me configure my database and then explain how I can run queries based on user input to return data?

Hi KJAK,

KJAK:

I am using SQLServer Express and Visual Studio 2005 to create the website.

In the SQL Express Edition, you have to do some more work the in the other SQL editions.

KJAK:

I cannot seem to figure out how to use a FT search using Visual Studio.

Use the Sql Server Management Studio Express. Open the Template Explorer, select the Full-text folder and select theCreate Full-text Index template. Fill in the needed information and run it. Then select theCreate Full-text Catalog template and do the same.

BTW. Sql-BOL is your friendSmile

|||

What I have now figured out is that I will not be able to implement FULL-TEXT search on this particular site. I am using a shared hosting provider and they do not provide me access via the Sql Server Management Studio Express because they do not permit remote connections. I have some documentation that may help me get around this issue to configure the database, but since the database is provided by the host, it may not work.

I have marked your reply as answered as a way to thank you for your help and will keep this post in mind when I am working with dedicated server websites.

Thanks for your reply!
KJAK

|||

KJAK:

I have some documentation that may help me get around this issue to configure the database, but since the database is provided by the host, it may not work.

Is your DataBase transmitted to the ISP sql server, or its a dynamically attached DataBase in your App_Data folder?

In the second case, AFAIK Full-text search wount works, because you need access to the Fulltext-Catalog directory to populate your index.

|||

The database is located on the hosts network. They provide a client that I connect to in which I can define tables, stored procedures, schema's, et cetera. It does not provide me access to the catalogs and is limited in what I can do all together. I have not yet spoken to the host to see if they can explain how to do it or whether I can do it or not.

|||

KJAK:

It does not provide me access to the catalogs and is limited in what I can do all together.

You may change to a ISP they will give you a dedicated SQL server. Or live with this restrictionsSmile

Full-Text Search in SQL Server Express?

Hi, all,

I heard a rumor that the next CTP of SQL Server Express would allow installation of full-text searching (MSFTE). Has anyone else heard this? Is it true?

Thanks,
Mike

Hi, all,

Looks like it's true: http://news.com.com/2100-1012_3-6062696.html?part=rss&tag=6062696&subj=news.

Thanks,
Mike

Full-Text Search in SQL Server Express?

Hi, all,

I heard a rumor that the next CTP of SQL Server Express would allow installation of full-text searching (MSFTE). Has anyone else heard this? Is it true?

Thanks,
Mike

Hi, all,

Looks like it's true: http://news.com.com/2100-1012_3-6062696.html?part=rss&tag=6062696&subj=news.

Thanks,
Mike

Full-Text Search in SQL Server 2005 express

I installed SQL Server 2005 express with advanced services which is supposed to include full-text search capability but I can't get it to work. When I try to create a full-text catalog it gives me an error because it does not think the full-text service is installed or loaded. I can't seem to find a reference to the full-text search feature to enable or install it. any ideas?

There are problems as you already know but there is a work around solution in the link below. Hope this helps.

http://www.wherecanibuyit.co.uk/ASP/full-text-search.html

|||

That was helpful. Thanks. I had to remove sql server 2005 express and reinstall it and then everything worked fine.

Caddre:

There are problems as you already know but there is a work around solution in the link below. Hope this helps.

http://www.wherecanibuyit.co.uk/ASP/full-text-search.html

|||

dsa1971:

That was helpful. Thanks. I had to remove sql server 2005 express and reinstall it and then everything worked fine.

Caddre:

There are problems as you already know but there is a work around solution in the link below. Hope this helps.

http://www.wherecanibuyit.co.uk/ASP/full-text-search.html

I am glad I could help.

fulltext search in sql express 2005

I had problem when change database from sqlserver 2000 to sql express 2005.

The fulltext index does not create automatically.

Example:

i use sqldatasource to insert new name to my table.

and then i find it by query like this : select count(*) from mytable where contains(mycol,'newname')

the result is 0

but if i run query to start full index : exec sp_fulltext_catalog 'myfulltext','start_full' and run query

select count(*) from mytable where contains(mycol,'newname')

again. The result is 1.

So i alway run exec sp_fulltext_catalog 'myfulltext','start_full' after insert or update, delete to create fulltext index. When i use sql server 2000 , i didn't need do that, it automatic.

Pls help me !!! how to make fulltext index create auto in sql express 2005 .


You need to set "Change Tracking" to automatic.

The index update will not be instantaneous, but it will be automatic.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=680500&SiteID=1

http://technet.microsoft.com/en-us/library/ms187317.aspx

full-text search failed with one million of key words (Sqlserver20

Hello,
I have to make big tests with sql server 2005 express (i'm waiting credits
to buy a full license).
I detected a big problem with my full-text search, and i don't know if it's
a bad use of Sql Server or if it's impossible to do it!
Here's my use case :
a table like this :
primary-key | data
1 | toto value1
2 | toto value2
3 | toto value3
...
1000001 | toto value1000001
So my table contains one millions of rows. Also, my index contains one
million+one key words : "toto" and all the "valueXXXX".
if i make those requests :
select count(primary-key) from table where contains(data,'"toto"') -> ok,
1000001
select count(primary-key) from table where contains(data,'"value5321"') ->
ok, 1
select count(primary-key) from table where contains(data,'"t*"') -> ok,
1000001
select count(primary-key) from table where contains(data,'"v"') -> KO, error
message "too complex request ect". I was expected 1000001.
Can someone help me ? I'm sure sql server 2005 can do it, but i'm also sure
i forgot an option...
Note : i work on a database who contains several millions rows, and
sometimes, users need to make some insert/update of several thousands of
rows. So they need to make very big requests to check the insert/update.
And i'm not english, so sorry for the mistakes ;-)
Thanks to all !
Hi Europa_Lili,
I assume the query you're submitting (the one that fails) actually looks like
select count(primary-key) from table where contains(data,'"v*"')
(i.e. with a * after v, meaning it's a prefix query)
SQL 2005 FTS will throw this error when the prefix identifies too many
distinct keywords that match it. What are the semantics of the query you're
trying to accomplish?
Another advice: if every row of your table contains "toto", then there's no
point in indexing it since querying for it provides no value. It will just
unnecessarily increase the size of your index. You may consider adding it to
the list of noise words. See SQL Books Online for information on noise word
files and how to change them (you'll need to re-index your data).
"Europa_Lili" wrote:

> Hello,
> I have to make big tests with sql server 2005 express (i'm waiting credits
> to buy a full license).
> I detected a big problem with my full-text search, and i don't know if it's
> a bad use of Sql Server or if it's impossible to do it!
> Here's my use case :
> a table like this :
> primary-key | data
> --
> 1 | toto value1
> 2 | toto value2
> 3 | toto value3
> ...
> 1000001 | toto value1000001
> So my table contains one millions of rows. Also, my index contains one
> million+one key words : "toto" and all the "valueXXXX".
> if i make those requests :
> select count(primary-key) from table where contains(data,'"toto"') -> ok,
> 1000001
> select count(primary-key) from table where contains(data,'"value5321"') ->
> ok, 1
> select count(primary-key) from table where contains(data,'"t*"') -> ok,
> 1000001
> select count(primary-key) from table where contains(data,'"v"') -> KO, error
> message "too complex request ect". I was expected 1000001.
> Can someone help me ? I'm sure sql server 2005 can do it, but i'm also sure
> i forgot an option...
> Note : i work on a database who contains several millions rows, and
> sometimes, users need to make some insert/update of several thousands of
> rows. So they need to make very big requests to check the insert/update.
> And i'm not english, so sorry for the mistakes ;-)
> Thanks to all !
>
|||Hello,
thanks a lot for your answer.
Research with "toto" was just a test. In real life, my database contains
some informations (text, colours, ect) about picture files . Pictures come
from big old books numerisation. (Sometimes, we've got 500 to 1000 pictures
for only one book) And the table i want to query looks like this :
primary-key | data-text | file name
| localization
1 | page 1 of a book toto | new_york_library_522 |
C:/newyork
2 | page 2 of a document | paris_library_81
| D:/library_paris 3 | image from a old
book | new_york_library_523 | C:/newyork
......
Here is a exemple of what i have to do :
we receive 500 000 files (all the old books of one library). All the files
have a name like this "NAME_LIBRARY_XXXXXXXXX" where X is a number.
And i need to select all these files to make some update actions in the
database.
I can't use the date.
so i need a query like "select * from mytable where
contains(file-name,'"NAME_LIBRARY_*"')".
And it don't work, because there's 500 000 results.
Another idea to help me ?
Have a good day and thanks for all
"denistc" wrote:
[vbcol=seagreen]
> Hi Europa_Lili,
> I assume the query you're submitting (the one that fails) actually looks like
> select count(primary-key) from table where contains(data,'"v*"')
> (i.e. with a * after v, meaning it's a prefix query)
> SQL 2005 FTS will throw this error when the prefix identifies too many
> distinct keywords that match it. What are the semantics of the query you're
> trying to accomplish?
> Another advice: if every row of your table contains "toto", then there's no
> point in indexing it since querying for it provides no value. It will just
> unnecessarily increase the size of your index. You may consider adding it to
> the list of noise words. See SQL Books Online for information on noise word
> files and how to change them (you'll need to re-index your data).
> "Europa_Lili" wrote:

Sunday, February 19, 2012

FullText Search & SQL Server Express Edition

Does SQL Server Express Edition with advanced Features Support Full text
Search, I am really confused because I have some resources telling that it
does support and others telling it don't
thank you
Hello yaser,
SQLExpress doesn't, SQL Express with Advanced Features does
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> Does SQL Server Express Edition with advanced Features Support Full
> text Search, I am really confused because I have some resources
> telling that it does support and others telling it don't
> thank you
>
|||Thank you Simon for your Reply

full-text queries with express edition

Hi,
I understand that full-text indexing is not available in the express
edition.
My situation is that we have to write an application to take advantage of
full-text-indexing when available.
Quesitions are.
1. Does "freetext" and "contains" queries works on express edition?
(by doing a full table scan or something like that)
2. If it does not, how do I write the c# that recognize the capability,
so that c# code can send/execute different queries based on
"full-text-capability" of sql-server.
any direction is deeply appreciated.
Thanks
Nalaka
1) It currently does not work on SQL FTS.
2) I believe the February issue of SQL Server pro has an article on how to
get this working using pure tsql.
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
"Nalaka" <nalaka12@.nospam.nospam> wrote in message
news:u%23h7eJNMGHA.2336@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I understand that full-text indexing is not available in the express
> edition.
> My situation is that we have to write an application to take advantage of
> full-text-indexing when available.
> Quesitions are.
> 1. Does "freetext" and "contains" queries works on express edition?
> (by doing a full table scan or something like that)
> 2. If it does not, how do I write the c# that recognize the capability,
> so that c# code can send/execute different queries based on
> "full-text-capability" of sql-server.
> any direction is deeply appreciated.
> Thanks
> Nalaka
>
|||Nalaka wrote on Mon, 13 Feb 2006 11:19:10 -0800:

> Hi,
> I understand that full-text indexing is not available in the express
> edition.
> My situation is that we have to write an application to take advantage of
> full-text-indexing when available.
> Quesitions are.
> 1. Does "freetext" and "contains" queries works on express edition?
> (by doing a full table scan or something like that)
> 2. If it does not, how do I write the c# that recognize the capability,
> so that c# code can send/execute different queries based on
> "full-text-capability" of sql-server.
> any direction is deeply appreciated.
In my code I first do the following:
select FULLTEXTCATALOGPROPERTY('STKcatalog', 'ItemCount'),
FULLTEXTCATALOGPROPERTY('STKcatalog', 'PopulateStatus')
If NULLs returned, FTS is not available for the named catalog (in my case
STKcatalog). I also use these values to double check whether the index is
being rebuilt, and to make sure that the ItemCount value is close to my
table row count. This way if there is not FTS catalog, or it's being
populated, I can switch my query to use LIKE rather than CONTAINS.
Dan