Easy questions about replication & Publication

Hi...
We have a SQL Server Std Edition that make syncronisation(merge
publication) with 100 mobile device.We create100 publications according to
our employees user id.We use articles with joins and user id for all
publications.The mobile devices make syncronisation over this publications.
Problem1:When I execute an insert or update statement in database , it cost
min 10 minutes for response.Last night I execute an update sql(for 10 rows)
at night.When i wake up morning,the transaction log is get full, and only 2
of the updates make succesfully.
Why database ddl operations get a long time to execute?
Problem2:How can I control transaction log automatically?
I'll wait for your answers..
Thanks...
answered above.
http://www.zetainteractive.com - Shift Happens!
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
"The_TOZ" <tunc@.te-mob.com> wrote in message
news:65A79B21-C9D6-498A-BC7F-3E2053C53EF3@.microsoft.com...
> Hi...
> We have a SQL Server Std Edition that make syncronisation(merge
> publication) with 100 mobile device.We create100 publications according to
> our employees user id.We use articles with joins and user id for all
> publications.The mobile devices make syncronisation over this
> publications.
>
> Problem1:When I execute an insert or update statement in database , it
> cost min 10 minutes for response.Last night I execute an update sql(for
> 10 rows) at night.When i wake up morning,the transaction log is get full,
> and only 2 of the updates make succesfully.
> Why database ddl operations get a long time to execute?
> Problem2:How can I control transaction log automatically?
> I'll wait for your answers..
> Thanks...

each time I build program, data is lost

I am using visual basic 2008

I am making a program, I used sql server compact edition (sdf) (i think it is no more only for mobile device, I am working for desktop application)which i created with the same visual basic. i update data by using table adapters,

when I close the program and build again, the data previosly updated are deleted, and I get empty database? why is that. do i need to set some copy to.........properties. i have used copy if new.

I want to add something to it, that when I manually entered data, they are not gone. But when I entered from form, next time the data lost.|||

See this: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2115234&SiteID=1