How to create and schedule full-text catalogue

Hi,
I have writen a database installation application that simply creates
tables inside a database. I also need to create and schedule
full-text indexing on some of my tables.
I am using SQL server 2000 and and VB.NET 2003.
Thank you,
_dino_You could generate scripts for full-text indexes from Enterprise Manager.
Here's how the scripts look like for example:
http://www.databasejournal.com/features/mssql/article.php/1459591
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dino Buljubasic" <dino@.noplacelikehome.com> wrote in message
news:jgale198gjv7suate4st95si2v5it5tbf4@.4ax.com...
> Hi,
> I have writen a database installation application that simply creates
> tables inside a database. I also need to create and schedule
> full-text indexing on some of my tables.
> I am using SQL server 2000 and and VB.NET 2003.
> Thank you,
> _dino_
>|||Thank you
On Sat, 30 Jul 2005 11:30:20 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:
>You could generate scripts for full-text indexes from Enterprise Manager.
>Here's how the scripts look like for example:
>http://www.databasejournal.com/features/mssql/article.php/1459591|||thank you
On Sat, 30 Jul 2005 11:30:20 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:
>You could generate scripts for full-text indexes from Enterprise Manager.
>Here's how the scripts look like for example:
>http://www.databasejournal.com/features/mssql/article.php/1459591

How to create and schedule full-text catalogue

Hi,
I have writen a database installation application that simply creates
tables inside a database. I also need to create and schedule
full-text indexing on some of my tables.
I am using SQL server 2000 and and VB.NET 2003.
Thank you,
_dino_
You could generate scripts for full-text indexes from Enterprise Manager.
Here's how the scripts look like for example:
http://www.databasejournal.com/featu...le.php/1459591
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dino Buljubasic" <dino@.noplacelikehome.com> wrote in message
news:jgale198gjv7suate4st95si2v5it5tbf4@.4ax.com...
> Hi,
> I have writen a database installation application that simply creates
> tables inside a database. I also need to create and schedule
> full-text indexing on some of my tables.
> I am using SQL server 2000 and and VB.NET 2003.
> Thank you,
> _dino_
>
|||Thank you
On Sat, 30 Jul 2005 11:30:20 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:

>You could generate scripts for full-text indexes from Enterprise Manager.
>Here's how the scripts look like for example:
>http://www.databasejournal.com/featu...le.php/1459591
|||thank you
On Sat, 30 Jul 2005 11:30:20 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:

>You could generate scripts for full-text indexes from Enterprise Manager.
>Here's how the scripts look like for example:
>http://www.databasejournal.com/featu...le.php/1459591

How to create and schedule full-text catalogue

Hi,
I have writen a database installation application that simply creates
tables inside a database. I also need to create and schedule
full-text indexing on some of my tables.
I am using SQL server 2000 and and VB.NET 2003.
Thank you,
_dino_You could generate scripts for full-text indexes from Enterprise Manager.
Here's how the scripts look like for example:
http://www.databasejournal.com/feat...cle.php/1459591
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dino Buljubasic" <dino@.noplacelikehome.com> wrote in message
news:jgale198gjv7suate4st95si2v5it5tbf4@.
4ax.com...
> Hi,
> I have writen a database installation application that simply creates
> tables inside a database. I also need to create and schedule
> full-text indexing on some of my tables.
> I am using SQL server 2000 and and VB.NET 2003.
> Thank you,
> _dino_
>|||Thank you
On Sat, 30 Jul 2005 11:30:20 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:

>You could generate scripts for full-text indexes from Enterprise Manager.
>Here's how the scripts look like for example:
>http://www.databasejournal.com/feat...cle.php/1459591|||thank you
On Sat, 30 Jul 2005 11:30:20 +0100, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:

>You could generate scripts for full-text indexes from Enterprise Manager.
>Here's how the scripts look like for example:
>http://www.databasejournal.com/feat...cle.php/1459591

How to create a new user.

Hi!

I have downloaded the MSDE from the Microsoft site.

The installation of Forums Stater Kit unable to add ASPNET account in MSDE users list.

Can anyone tell me how i should add this user by myself in to MSDE users.

i don't have any enterprise manager etc. thing. Just MSDE.

and also what will be the password for this account [ASPNET]http://www.1000files.com/Software_Development/Databases_and_Networks/web_based_msde_admin_tool_-_Shusheng_SQL_Tool_3887_Review.html is a link to a free web based admin tool. ASPNET is automagically created when you installed ASP.NET and the .net framework. You won't know the password. HTH

How to create a new named instance

Hi,

I did install SQL-server developer edition. During the installation it asked me the name of de instance. I let the installation create the default Named instance.

Now I want to add an instance with a new name. What is the best way to do this? Is this the same as creating a Notification service?

Doeb

Simply run setup again, this time choosing a named instance instead of the default. Each instance will operate independently of the other.|||

Thank you, I'll be able to create a new instance during new setup.

Is there no other way? e.g. with Notification Service?

Because when distributing my app I would prefer to have a new created named instance with our company name.

|||

No other way than that...but when you distribute your app, depending on what you're using for SQL Server editions, you can perform unattended installations that name your instance the way you like automatically. Guess I'd need more info on what you're doing here to give you any further assistance...

Notification services is not for performing installations of the database engine, it's a seperate component of SQL Server that is used for messaging, etc.

|||Thankx.