Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pfdtv
Starting Member
10 Posts |
 Posted - 2008-07-18 : 15:11:03
|
| Hi,I am using MS SQL Server Management System Express with Advanced Services.I am trying to create a google-like search engine for a production database for which I have strictly read-only permissions. It is updated every 24 hours and there is no change log whatsoever, so any copies or indexes will also need to be recreated every 24 hours. My preferred method would be to index the read-only production database remotely and store the index locally. Does the express edition have these capabilities? I have not been able to determine this from the web, and I have not attained the necessary permissions to try the indexing features out.As a plan b, I could make a copy of the production database and store it locally, then I could proceed in indexing and searching. Does the replication features allow copying select fields from a large table?Thanks for your help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-18 : 15:32:03
|
| I don't understand what you mean by storing the index locally. Are you referring to an index on a table? If so, it gets stored in the database.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
pfdtv
Starting Member
10 Posts |
Posted - 2008-07-18 : 15:34:24
|
| Yes. I am trying to create a full-text catalog and index, but since I cannot create it on the production database (permissions), I was wondering if it's possible to create the index and store it elsewhere, where I can attain write permissions. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-19 : 13:18:11
|
| No, you can't. Has to be on local disk of the server. |
|
|
|
|
|
|
SQL Server Express Indexing/Replication Questions