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 2000 how many users

How many users and transaction can handle MSDE 2000. I have an application w
ith 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 anythi
ng about it. Any additional information I would appreciate.
Sincerely,
RafaelHi
There is quite alot of information in Books Online which can be downloaded
at
http://www.microsoft.com/downloads/...&displaylang=en
For information on the workload govenor see
http://msdn.microsoft.com/library/d...r />
_0neh.asp
http://msdn.microsoft.com/library/d...r />
_5fs6.asp
For capacity details see
http://msdn.microsoft.com/library/d...br />
8dbn.asp
For features see
http://msdn.microsoft.com/library/d...br />
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 addit
ion
al information I would appreciate.
> Sincerely,
>
> Rafael|||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 w
ith 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 anythi
ng about it. Any additional information I would appreciate.
Sincerely,
Rafael|||"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) .sql

MSDE

How does MSDE handle data mangement? Does it come with sql analyser or some sort of database manager?
Thanks.I don't believe it comes with anything. I think the general idea is that you develop it using the tools you mention and then ship the MSDE like you would an runtime Access database.|||pkr hit it on the nose. If you are using MSDE in conjunction with ASP.NET Web Matrix, you would use Web Matrix's built-in database management tool. If you are using MSDE with Microsoft Access you would use Accesss for the database management.

Some other options for managing MSDE:
-- using the built-in OSQL command line utility:HOW TO: Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql Utility

--ASP.Net EnterpriseManager

--Web Data Administrator

--ASP.NET Web Matrix includes a database management tool

-- SQL Enterprise Manager and Query Analyzer -- the SQL Server 2000 client tools (note that there are licensing requirements)

-- there are other 3rd party tools such as "MSDE Manager" and "MyLittleAdmin"

Terri|||My main need is maintaining data tables, stored procs, triggers, udf etc...
What tool would allow me to edit stored procs, triggers, udf specifically?
Thanks again.|||You would have to investigate that to see which tool met your needs.

To the best of my knowledge, only SQL Enterprise Manager and Query Analyzer would enable you to everything you are looking for.

Terri|||Query Analyzer and Enterprise Manager are really what you're looking for. I know you can now buy SQL Server Developer Edition for $49 and it comes with both Query Analyzer and Enterprise Manager.

If you don't want to spend the money you can go with the open source, Query Analyzer like tool called SqlBuddy. Here's the link, http://sqlbuddy.sourceforge.net/.

Good luck.