Connect .mdf file to MSDE 2000

I'm using a product (SAP Business one) using MSDE 2000A. Another product I
receintly bought also uses SQL. According to this products manual I need to
connect the *.mdf database to my SQL server using SQL Enterprise Manager. How
does it work?
hi,
GV wrote:
> I'm using a product (SAP Business one) using MSDE 2000A. Another
> product I receintly bought also uses SQL. According to this products
> manual I need to connect the *.mdf database to my SQL server using
> SQL Enterprise Manager. How does it work?
you are required to "attach" the provided database to an existing SQL
Server/MSDE instance...
as MSDE does not provide Entrprise Manager, you have to resort on the
command line tool, oSql.exe, to execute the corresponding Transact-SQL
statement to attach the database using the system stored procedure
sp_attach_db...
you can find the full synopsis of the introduced stored procedure at
http://msdn.microsoft.com/library/de...ae-az_52oy.asp
at http://support.microsoft.com/default...;EN-US;q325003 you will
find some information on how to use oSql.exe to perform this task as long as
other related management tasks..
for your convenience, you can have a look at a free prj of mine, available
at the link following my sign., which provides a graphical user interface
similar to Enterprise Manager in order to accomplish management tasks,
including the one here discussed..
futher tools for MSDE, both commercial and free, are listed
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Confusion: "Manual", "Incremental", "Update"

Hi,
I'm using SQL Server 2005. What's difference between mechanisms of "Manual"
update and "Incremental" population? I also need some clarification about
"Update" type of population.
Thanks in advance,
Leila
There are three population types, full, incremental and change tracking.
Change Tracking can be continuous or on demand (Manual). When using the
Change Tracking - manual option you must run a ALTER FULLTEXT INDEX ON
TableName START UPDATE to process the tracked changes.
No matter what population method you try a full population will always be
done first. If you have a timestamp column on your table and have already
done an full population, an incremental population will be done.
Change tracking will track changes which occur to the columns you are
full-text indexing. They will be indexed near real time, or at scheduled
intervals using the alter command mentioned above.
A Full population will index every row on your table whenever it is run. An
incremental population will extract each row from your table and detect if
it has changed (it can't detect if the change occured to a column which you
are full-text indexing or not), and it will then compare it with its list to
see what has been deleted and then update the catalog with the
updated/deletions. Incremental populations take almost as long as
full-populations. Use incremental populations when small amounts of data
changes at discrete times. By small I mean around 40-80% or so. Use Full
when more than 90% occurs at any one time. Use change tracking everywhere
else. Your numbers may vary.
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
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23fDNVdwRHHA.1200@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I'm using SQL Server 2005. What's difference between mechanisms of
> "Manual" update and "Incremental" population? I also need some
> clarification about "Update" type of population.
> Thanks in advance,
> Leila
>
|||Thanks indeed Hilary!
1) Can I conclude that: When we use change tracking (manual), we must use
ALTER FULLTEXT INDEX by considering whether we have timestamp column or not.
If we have, then we must use START INCREMENTAL, unless START UPDTAE?
2) How the changes are tracked when we don't have timestamp column?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OYvp08wRHHA.4632@.TK2MSFTNGP04.phx.gbl...
> There are three population types, full, incremental and change tracking.
> Change Tracking can be continuous or on demand (Manual). When using the
> Change Tracking - manual option you must run a ALTER FULLTEXT INDEX ON
> TableName START UPDATE to process the tracked changes.
> No matter what population method you try a full population will always be
> done first. If you have a timestamp column on your table and have already
> done an full population, an incremental population will be done.
> Change tracking will track changes which occur to the columns you are
> full-text indexing. They will be indexed near real time, or at scheduled
> intervals using the alter command mentioned above.
> A Full population will index every row on your table whenever it is run.
> An incremental population will extract each row from your table and detect
> if it has changed (it can't detect if the change occured to a column which
> you are full-text indexing or not), and it will then compare it with its
> list to see what has been deleted and then update the catalog with the
> updated/deletions. Incremental populations take almost as long as
> full-populations. Use incremental populations when small amounts of data
> changes at discrete times. By small I mean around 40-80% or so. Use Full
> when more than 90% occurs at any one time. Use change tracking everywhere
> else. Your numbers may vary.
> --
> 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
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23fDNVdwRHHA.1200@.TK2MSFTNGP02.phx.gbl...
>