Showing posts with label match. Show all posts
Showing posts with label match. Show all posts

Friday, March 23, 2012

How to tell which service pack of SQLCE is installed on the desktop

The title about says it all. For merge replication, I need to make sure the
service packs match up between SQL2000 and SQLCE. How do I tell which SQLCE
version is in?
IIRC check the folder C:\Program Files\Microsoft SQL Server CE
2.0\Redist\Server, the latest one should be there.
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
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:esst%23$86FHA.1864@.TK2MSFTNGP12.phx.gbl...
> The title about says it all. For merge replication, I need to make sure
> the service packs match up between SQL2000 and SQLCE. How do I tell which
> SQLCE version is in?
>
|||actually this is good up to sp2. After sp 2 you need to check the versions
of the binaries in C:\Program Files\Microsoft SQL Server CE 2.0\Server\
For sp 4 they are
sscesa20.dll 2.00.7331.0
sscerp20.dll 2.00.7331.0
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
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:esst%23$86FHA.1864@.TK2MSFTNGP12.phx.gbl...
> The title about says it all. For merge replication, I need to make sure
> the service packs match up between SQL2000 and SQLCE. How do I tell which
> SQLCE version is in?
>
|||Thanks Hilary; that's helpful.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uLeiiSD7FHA.1032@.TK2MSFTNGP11.phx.gbl...
> actually this is good up to sp2. After sp 2 you need to check the versions
> of the binaries in C:\Program Files\Microsoft SQL Server CE 2.0\Server\
> For sp 4 they are
> sscesa20.dll 2.00.7331.0
> sscerp20.dll 2.00.7331.0
> --
> 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
> "Earl" <brikshoe@.newsgroups.nospam> wrote in message
> news:esst%23$86FHA.1864@.TK2MSFTNGP12.phx.gbl...
>