How to remove MSDE manually?

Please help me to clean a Windows 2000 Pro instance which is "dirty"
with the MSDE 7.0 and/or/both MSDE 8.0 previously incorrect
installed/removed.

I have a software product installation containing MSDE 7.0. When I tried
to install MSDE 7.0 I got an error "You have installed MSDE".

*** Sent via Developersdex http://www.developersdex.com ***http://support.microsoft.com/defaul...kb;en-us;276044
http://support.microsoft.com/defaul...kb;en-us;290991

Simon|||Thank you!
But it does not work in my case :(

*** Sent via Developersdex http://www.developersdex.com ***|||
> Please help me to clean a Windows 2000 Pro instance which is "dirty"
> with the MSDE 7.0 and/or/both MSDE 8.0 previously incorrect
> installed/removed.
> I have a software product installation containing MSDE 7.0. When I tried
> to install MSDE 7.0 I got an error "You have installed MSDE".
Frankly speaking I think that the surest way to do this is reinstallation of
OS. I am afraid that manual removal would take more time then reinstallation
of OS and all additional software.

Alwik|||can't you just disable the service and kill all the files?|||> can't you just disable the service and kill all the files?
It will leave a lot of trash in registry and next attempt to install MSDE
may be not sucessful.

Alwik
www.akwarele.com

how to remove MSDE

How do I completely remove MSDE so I can do a new clean install?
This should help:
http://support.microsoft.com/default...;EN-US;q290991
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Hugh N. Ross" <bytewise@.optonline.net> wrote in message
news:DtDdd.33521$YM4.10095492@.news4.srv.hcvlny.cv. net...
> How do I completely remove MSDE so I can do a new clean install?
>
sql

How to query for records that have not been replicated

Hi,

I am using Merge Replication for synchronizing a bunch of laptops
running MSDE with a central SQL Server 2000 production server.

This database is used by an application that needs to know which
records have not yet been replicated, at any givem time.

Here's a simple scenario:

User A in laptop X starts his copy of the application. He syncs his
MSDE database through the application, to match the current central
servers' data. He then proceeds to add new records through the
application and, after he is done, he synchronizes his database with
the central server, through the application.

At any given time, the user might kill the application. He might add
some records today, a few more tomorrow or in a week and should be able
to change and delete records that have not yet been merged into the
production server.

The problem is that SQL Server does not have an easy way to tell which
records in the subscription tables have been inserted but not yet
replicated. I have been using the following query:

SELECT rowguid
FROM [MyTable]
INNER JOIN (
SELECT rowguid AS rep_id
FROM msmerge_contents
WHERE generation = joinchangegen AND generation = (
SELECT MAX(generation)
FROM msmerge_genhistory )
) dtable
ON rowguid_rep = dtable.rep_id

This query works for most cases but fails to identify the first record
created immediatly after a synchronization event.

What I would like to know is if there is a correct way of identifying
records which are "not-yet-replicated" on a given table that is part of
a merge replication process like the one described above.
Thanks in advance.<miltonmoura@.gmail.com> wrote in message
news:1104839914.237873.95740@.f14g2000cwb.googlegro ups.com...
> Hi,
> I am using Merge Replication for synchronizing a bunch of laptops
> running MSDE with a central SQL Server 2000 production server.

<snip
> What I would like to know is if there is a correct way of identifying
> records which are "not-yet-replicated" on a given table that is part of
> a merge replication process like the one described above.
> Thanks in advance.

I have no idea myself, but you might get a better response in
microsoft.public.sqlserver.replication.

Simon