MSDE and Full Text Search Catalog

Hi there,
First off: I know that MSDE can't handle Full Text Catalogs.

Now I'd like to know if someone knows about a product or method which I could use that would give me the same result and work with MSDE.

The reason I ask is the following:
We have developed an Intranet application based upon MS Sharepoint Portal Server 2003 for Document Management purposes. Every Document has about 20 customized Properties which can be set. We do have an extensive interface for searching these documents
Now every user can have his "Favorite Documents" in a personal location.
What we are doing now is a "Local" version of this application. It will not allow documents to be modifed and will export the Users Favorites to his personal Computer.
For the moment we store everything (including the documents themselves) in a local MSDE Database.
Now we were recently asked to allow the user to search these local documents. Or at least search for documents with specific properties(i.e. no content indexing needed)

However I don't know how to go about this.

The structure I have for the DB is following

tblFiles
FileGUID FileName
1 Doc1
2 Doc2

tblProperties
PropertyGUID PropertyName
1 Name
2 Author

tblFileProperties
FileGUID PropertyGUID Value
1 1 Test Document.doc
1 2 John Smith
2 1 Dcoument for testing.xls
2 2 John Doe

Now you get the idea

We want to user to be able to specify search criteria for multiple properties
e.g. return every Document where Author Like 'John' and Name Like 'Document'
Preferably we should also be able to use wildcars. But that is not abolutely necessary for the moment.

Now I guess to achieve this I'd need a full text Search Catalog on tblFileProperties.Value, but I'm not even sure about that.

Any help please

RizziManIf your documents are in TEXT you can still search for them using SELECT and XML in SQL Server, the search will just be longer because SQL Server creates an Arithmetic pointer to the file. Full Text is Microsoft Proprietry technology that includes the search with CONTAINS and other key words. Full Text requires Microsoft Catalog to be populated before searches because it is not fully integrated into SQL Server, if the catalog is not populated your search will be empty. If your named concurrent users are less than 75 you can implement the Premium Small business Server 2003 and use the SQL Server that comes with it. Hope this helps.

Kind regards,
Gift Peddie|||I'm gonna have a look at what you suggested using SELECT and XML. (btw, the document content don't even need to be indexed. Only the Properties. But that should work the same way I guess)

The point is: this will be a local application with only 1 concurrent user. We do have SQL Server with Full Text Calatlog Licenses on a few servers running. But this is supposed to work on peoples Laptop when they are not connected to our company network. So I can only work with free software here as the management won't agree on buying any licenses.

Anyway, thank you for the help

Anyone else?

MSDE and Cyrillic

I have a table content in my database. This table has 5 fields(id, lang1, lang2 ...) type text. The problem is that one of the language fields has to contain some text in Cyrillic but after insert it always converts the text into "?? ????? ????". Can anyone help?

What you are getting is called character conversion but you are lucky I have helped someone at another site with Cyrillic character conversion. You enable column level collation for all the langauges your site support and the problem will be resolved. You need Enterprise manager to do it manually so use the link below to download the Eval version of SQL Server install it as a named instance and register your MSDE and in Query Analyzer right click on the tables in question and generate the create table statement and modify it to include the collation of all the languages used in the database. Run a search for column level collation in the BOL (books online). If you need more help post again. Hope this helps.

http://www.microsoft.com/sql/evaluation/trial/default.mspx

MSDE 2GB Limit

Hi
A Client has an MSDE install - checked by running @.@.version (clearly
says developer edition in the result text).
However the size of the data file is over 3GB, even allowing for empty
spaces the amount of data far exceeds 2GB. Pls explain?
The database was filled by regular insert statements.
Am 31 Oct 2005 04:14:49 -0800 schrieb yitzak:

> Hi
> A Client has an MSDE install - checked by running @.@.version (clearly
> says developer edition in the result text).
> However the size of the data file is over 3GB, even allowing for empty
> spaces the amount of data far exceeds 2GB. Pls explain?
> The database was filled by regular insert statements.
MSDE always shows "Desktop Engine" and not "Developer Edition"!
bye,
Helmut

MSDE 2000sp3 and Full Text Indexing (Search Server)

I am new to MSDE, does anyone know if it comes with
Search Server or is that a full SQL Server app? If it is
available, how do I install it, or do I need to by it?
Thanks
Chris
Full-Text Search is not included with MSDE. It comes with the Enterprise,
Server, Personal (except on Windows 98), Developer, and Enterprise
Evaluation Editions.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Griffin" <msde@.doc-capture.co.uk> wrote in message
news:060d01c4b6c2$e0e65a80$a401280a@.phx.gbl...
>I am new to MSDE, does anyone know if it comes with
> Search Server or is that a full SQL Server app? If it is
> available, how do I install it, or do I need to by it?
> Thanks
> Chris
|||hi Chris,
"Chris Griffin" <msde@.doc-capture.co.uk> ha scritto nel messaggio
news:060d01c4b6c2$e0e65a80$a401280a@.phx.gbl
> I am new to MSDE, does anyone know if it comes with
> Search Server or is that a full SQL Server app? If it is
> available, how do I install it, or do I need to by it?
> Thanks
unfortunately MSDE does not support Full Text...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE 2000 how many users

This is a multi-part message in MIME format.
--=_NextPart_000_000B_01C68BB6.585C23A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
How many users and transaction can handle MSDE 2000. I have an = application with 2 pc and I would like to know if MSDE 2000 would work = perfectly on that environment. I was reading the MSDE documentation and = I did not found anything about it. Any additional information I would = appreciate.
Sincerely,
Rafael
--=_NextPart_000_000B_01C68BB6.585C23A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
How many users and transaction can = handle MSDE 2000. I have an application with 2 pc and I would like to know if MSDE = 2000 would work perfectly on that environment. I was reading the MSDE = documentation and I did not found anything about it. Any additional information I = would appreciate.

Sincerely,


Rafael
--=_NextPart_000_000B_01C68BB6.585C23A0--Hi
There is quite alot of information in Books Online which can be downloaded
at
http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en
For information on the workload govenor see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_0neh.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_5fs6.asp
For capacity details se
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
For features se
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
If you have two users each with a single connection, you should be fine. You
throughput may be limited by the specification of the machine that it is
running on.
John
"Rafael Tejera" wrote:
> How many users and transaction can handle MSDE 2000. I have an application with 2 pc and I would like to know if MSDE 2000 would work perfectly on that environment. I was reading the MSDE documentation and I did not found anything about it. Any additional information I would appreciate.
> Sincerely,
>
> Rafael|||This is a multi-part message in MIME format.
--=_NextPart_000_00F2_01C68BB5.0B328700
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Why not use SQL Server 2005 Express Edition?
David
"Rafael Tejera" <rafaeltejera@.hotmail.com> wrote in message =news:uDRTNf9iGHA.836@.TK2MSFTNGP02.phx.gbl...
How many users and transaction can handle MSDE 2000. I have an =application with 2 pc and I would like to know if MSDE 2000 would work =perfectly on that environment. I was reading the MSDE documentation and =I did not found anything about it. Any additional information I would =appreciate.
Sincerely,
Rafael
--=_NextPart_000_00F2_01C68BB5.0B328700
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Why not use SQL Server 2005 Express =Edition?
David
"Rafael Tejera" = wrote in message news:uDRTNf9iGHA.836@.T=K2MSFTNGP02.phx.gbl...
How many users and transaction can =handle MSDE 2000. I have an application with 2 pc and I would like to know if MSDE =2000 would work perfectly on that environment. I was reading the MSDE =documentation and I did not found anything about it. Any additional information I =would appreciate.

Sincerely,


Rafael

---

--=_NextPart_000_00F2_01C68BB5.0B328700--|||"Rafael Tejera" <rafaeltejera@.hotmail.com> wrote in message
news:uDRTNf9iGHA.836@.TK2MSFTNGP02.phx.gbl...
How many users and transaction can handle MSDE 2000. I have an application
with 2 pc and I would like to know if MSDE 2000 would work perfectly on that
environment. I was reading the MSDE documentation and I did not found
anything about it. Any additional information I would appreciate.
Depends on the PC hosting. Is it at least Win2000 or XP (Pro)?
Then no problem. I have a few clients running a small network all with
MSDE. They have 10 users on their network and only a few are ever in the
app at any time (5) .

Msde 2000

Hello,
I just wanted to know from any MSDE 2000 users, if it supports Full Text indexing.
Thanks.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_0ehx.asp

The full-text engine runs as a service named Microsoft Search on Microsoft Windows NT Server, Windows NT Advanced Server, Windows 2000 Server, or Windows 2000 Advanced Server. It is installed when the Full-Text Search feature is selected during custom installation. The Microsoft Search service itself is not installed during an installation of SQL Server Desktop Engine. 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.sql