Install on Personal Edition 2000 SP3a

I installed SQL 2000 on a Windows XP box with a typical install, but
Full-Text Search does not appear to have been installed. It does not appear
at all. I want to go back and install it, but the install wants to create a
new instance. Can this be done without creating a new instance or
uninstalling and then reinstalling?
Thanks
It should work, can you issue this query?
select ServerProperty(N'IsFulltextInstalled')
This will tell you whether it is installed or not.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Audrey" <Audrey@.discussions.microsoft.com> wrote in message
news:16AC1E43-9D2F-4889-8527-90B05A3B6AC3@.microsoft.com...
> I installed SQL 2000 on a Windows XP box with a typical install, but
> Full-Text Search does not appear to have been installed. It does not
appear
> at all. I want to go back and install it, but the install wants to create
a
> new instance. Can this be done without creating a new instance or
> uninstalling and then reinstalling?
> Thanks
sql

Inside MDF file

Hi,
Is there any place where I can learn about the internal structure of a typical database file MDF ?
I'm not planning to do a competitor product Just want to know how it is internally organized.
Any link, articles, books recommendations are welcome.
Thanks,
"Inside SQL Server 2000" is a good start.
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,
|||Hi,
Have a look into the below link:-
http://msdn.microsoft.com/library/de...us/architec/8_
ar_da2_9sab.asp
Thanks
Hari
MCDBA
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,
|||Inside SQL Server 2000 by Kalen Delaney is one of the best books on the
subject. Books online has some information and Ken Henderson's Guru's Guide
to SQL Server Architecture looks promising (although I have not yet added
this one to my library).
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,

Inside MDF file

Hi
Is there any place where I can learn about the internal structure of a typical database file MDF
I'm not planning to do a competitor product :) Just want to know how it is internally organized
Any link, articles, books recommendations are welcome
Thanks,"Inside SQL Server 2000" is a good start.
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product :) Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,|||Hi,
Have a look into the below link:-
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_da2_9sab.asp
Thanks
Hari
MCDBA
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product :) Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,|||Inside SQL Server 2000 by Kalen Delaney is one of the best books on the
subject. Books online has some information and Ken Henderson's Guru's Guide
to SQL Server Architecture looks promising (although I have not yet added
this one to my library).
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product :) Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,

Inside MDF file

Hi,
Is there any place where I can learn about the internal structure of a typic
al database file MDF ?
I'm not planning to do a competitor product Just want to know how it is i
nternally organized.
Any link, articles, books recommendations are welcome.
Thanks,"Inside SQL Server 2000" is a good start.
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,|||Hi,
Have a look into the below link:-
http://msdn.microsoft.com/library/d...-us/architec/8_
ar_da2_9sab.asp
Thanks
Hari
MCDBA
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,|||Inside SQL Server 2000 by Kalen Delaney is one of the best books on the
subject. Books online has some information and Ken Henderson's Guru's Guide
to SQL Server Architecture looks promising (although I have not yet added
this one to my library).
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,