As Dejan suggested, you should probably consider a 3rd party tool or develop
your own for this functionality. This sort of thing will be much easier in
Yukon since you can write functions using .Net code, allowing you to
leverage managed APIs from within SQL Server.

Relevant Pages

3rd party replication tool... I'm not too sure why it has to be a 3rd party tool.... there is a big variety of functionality... within SQL Server itself to do this. ...(microsoft.public.sqlserver.replication)

Re: full-Text Search questions... I will search SQL Server BOL for information. ...TopCo Site / Employees ... The functionality in STS was to search the entire set of sites. ...(microsoft.public.sharepoint.portalserver.development)

Re: I have two questions about the TableAdapter Configuration Wizard... something to do with the difficulty in adding functionality to VS2005. ... Hitchhiker's Guide to Visual Studio and SQL Server... I want to have a TableAdapter that encapsulates a bunch of stored ... I might have 10 delete sprocs that I want to put into one ...(microsoft.public.dotnet.framework.adonet)

RE: access to SQL Server 2.0 CE from .NET Framework... You can use the remote application programming interface to accomplish this functionality of accessing a SQL Server CE database from your ...RAPI allows desktop apps to invoke function calls on your Windows CE device while the device is connected via ActiveSync to the desktop. ... you could write a device resident app which performed SQLCE functionality and call this app from your desktop. ...(microsoft.public.sqlserver.ce)