full text serch with no user istance?

HI

I' making an archive applicaton that will be distribuited on cd.

the application contain a simple database witn one million of document with author , title and full document in text format.

i want to make a full text serch on the documents.

this cd will be distribuited to normal user so it have to be simple to install and use.

in the cd I'have put the setup of sql server express advenced with the .ini file for an automatic setup with the required component(full-text serch engine too)

when the installation program has finished you have a directory with a simple c# program and the .mdf and .ldf file for the database.

in the database you have 4 columns "id" "title" "author" "text"

with "SQL Server Management Studio Express" I have create the full text on the database using this sql line

"CREATE FULLTEXT CATALOG cat" to create the catalog then I have create an index key on ID column and then a full text for text column.

now the probelm is that i can make a full-text serch in a user istance.

in visual studio 2005 i select the option "insert existing element in the project" then I'have select the mdf file, but after the insert all the query work fine expet the "SELECT * FROM db WHERE CONTAINS(tilte,'word')" it say me "unable to do a full-text serch in an user istance.

I'have tried to manipulate the connection string setting user istance=false but I have encountered two problem.

1- I can't set a file location like |program dir|\db.mdb

2- if i set a real file location the program work only on my pc and only if the visul studio in open.

whot I have to do to make it work?

Full-text Search does not work in User Instances.

Mike

|||

this means that is impossible with c# and sql server express advanced to make an application with full text serch, that can be distribuite on cd for normal user?

Full backup without change archive bit

Here's the scenario:
I set a maintenance plan for sqlserver:
monday morning : full backup
in 6 days rest : differential backup
Sometimes I need to make a full backup of some databases and send to client.
I've got a problem, when I have to make a full backup for example in friday
for someone , because all next differential backups from maintenance plan
are wrong.
(include only differences from friday - not from monday)
So I have a question. How to make a full backup without reset an archive
bit?.
Any idea ?
Thanks to all in advance for your worthy assistance,
Radoslaw PutekRadek
Can you perfom full BACKUP DATABASE on friday within another job ,I mean not
by maintenance plan?
"Radek" <SPAM_putti@.poczta.onet.pl> wrote in message
news:bnql59$77a$1@.atlantis.news.tpi.pl...
> Here's the scenario:
> I set a maintenance plan for sqlserver:
> monday morning : full backup
> in 6 days rest : differential backup
> Sometimes I need to make a full backup of some databases and send to
client.
> I've got a problem, when I have to make a full backup for example in
friday
> for someone , because all next differential backups from maintenance plan
> are wrong.
> (include only differences from friday - not from monday)
> So I have a question. How to make a full backup without reset an archive
> bit?.
> Any idea ?
> Thanks to all in advance for your worthy assistance,
> Radoslaw Putek
>|||> > Here's the scenario:
> > I set a maintenance plan for sqlserver:
> > monday morning : full backup
> > in 6 days rest : differential backup
> >
> > Sometimes I need to make a full backup of some databases and send to
> client.
> > I've got a problem, when I have to make a full backup for example in
> friday
> > for someone , because all next differential backups from maintenance
plan
> > are wrong.
> > (include only differences from friday - not from monday)
> >
> > So I have a question. How to make a full backup without reset an archive
> > bit?.
> > Any idea ?
> >
> > Thanks to all in advance for your worthy assistance,
> >
> > Radoslaw Putek
--
> Radek
> Can you perfom full BACKUP DATABASE on friday within another job ,I mean
not
> by maintenance plan?
>
--
I used my own backup procedures in jobs.
I have over 500 databases and these procedures make me :
SQL_20031029_FULL catalog
database1_full.bac
database2_full.bac
...
SQL_20031030_DIFF catalog
database1_diff.bac
database2_diff.bac
...
.....
And when i make a full backup of some databases in friday(for example) my
restore plan doesn't work.
Radoslaw Putek|||Radek
I'd go with writing stored procedure that accep parameter as database id.
If you were asked to backup particular database/or databases you just put
their id as parameter, that's all.
"Radek" <SPAM_putti@.poczta.onet.pl> wrote in message
news:bnqn9o$ht2$1@.atlantis.news.tpi.pl...
> > > Here's the scenario:
> > > I set a maintenance plan for sqlserver:
> > > monday morning : full backup
> > > in 6 days rest : differential backup
> > >
> > > Sometimes I need to make a full backup of some databases and send to
> > client.
> > > I've got a problem, when I have to make a full backup for example in
> > friday
> > > for someone , because all next differential backups from maintenance
> plan
> > > are wrong.
> > > (include only differences from friday - not from monday)
> > >
> > > So I have a question. How to make a full backup without reset an
archive
> > > bit?.
> > > Any idea ?
> > >
> > > Thanks to all in advance for your worthy assistance,
> > >
> > > Radoslaw Putek
> --
> > Radek
> > Can you perfom full BACKUP DATABASE on friday within another job ,I mean
> not
> > by maintenance plan?
> >
> --
> I used my own backup procedures in jobs.
> I have over 500 databases and these procedures make me :
> SQL_20031029_FULL catalog
> database1_full.bac
> database2_full.bac
> ...
> SQL_20031030_DIFF catalog
> database1_diff.bac
> database2_diff.bac
> ...
> .....
> And when i make a full backup of some databases in friday(for example) my
> restore plan doesn't work.
> Radoslaw Putek
>
>|||Radek,
As I understand it, your problem is that your diff backups will be based on that "extra" database
backup, something you don't want them to be. I'm fairly certain that you cannot do that, I'm afraid.
Detaching might be an option (but that is not fully online, of course).
This seems like a valid request for sqlwish@.microsoft.com.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Radek" <SPAM_putti@.poczta.onet.pl> wrote in message news:bnql59$77a$1@.atlantis.news.tpi.pl...
> Here's the scenario:
> I set a maintenance plan for sqlserver:
> monday morning : full backup
> in 6 days rest : differential backup
> Sometimes I need to make a full backup of some databases and send to client.
> I've got a problem, when I have to make a full backup for example in friday
> for someone , because all next differential backups from maintenance plan
> are wrong.
> (include only differences from friday - not from monday)
> So I have a question. How to make a full backup without reset an archive
> bit?.
> Any idea ?
> Thanks to all in advance for your worthy assistance,
> Radoslaw Putek
>|||Ok
Now I see what you mean?
Perhaps detach a database will be an option but I really don't know another
solution
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OdR673snDHA.2272@.tk2msftngp13.phx.gbl...
> Radek
> I'd go with writing stored procedure that accep parameter as database id.
> If you were asked to backup particular database/or databases you just put
> their id as parameter, that's all.
>
> "Radek" <SPAM_putti@.poczta.onet.pl> wrote in message
> news:bnqn9o$ht2$1@.atlantis.news.tpi.pl...
> > > > Here's the scenario:
> > > > I set a maintenance plan for sqlserver:
> > > > monday morning : full backup
> > > > in 6 days rest : differential backup
> > > >
> > > > Sometimes I need to make a full backup of some databases and send to
> > > client.
> > > > I've got a problem, when I have to make a full backup for example in
> > > friday
> > > > for someone , because all next differential backups from
maintenance
> > plan
> > > > are wrong.
> > > > (include only differences from friday - not from monday)
> > > >
> > > > So I have a question. How to make a full backup without reset an
> archive
> > > > bit?.
> > > > Any idea ?
> > > >
> > > > Thanks to all in advance for your worthy assistance,
> > > >
> > > > Radoslaw Putek
> > --
> > > Radek
> > > Can you perfom full BACKUP DATABASE on friday within another job ,I
mean
> > not
> > > by maintenance plan?
> > >
> > --
> > I used my own backup procedures in jobs.
> > I have over 500 databases and these procedures make me :
> > SQL_20031029_FULL catalog
> > database1_full.bac
> > database2_full.bac
> > ...
> > SQL_20031030_DIFF catalog
> > database1_diff.bac
> > database2_diff.bac
> > ...
> > .....
> > And when i make a full backup of some databases in friday(for example)
my
> > restore plan doesn't work.
> >
> > Radoslaw Putek
> >
> >
> >
> >
>