siz if you want more performance use this in your group by and select

dateadd

(d,datediff(d,0

Hi lance can you tell me on wich roles this user is included ?

If the result from the query is a value (No a table) you can use something like this.

DECLARE

@sql

nvarchar(

How did you setup the dinamic snapshot  , how many suscriber do you have.

i'm traing to do the same. But ussing the Sql server Winzards for all my 500 suscribers...

You may want to try modifying the replication profile in the sql server.

the amoutn of row per batch , give it an small number.

go to tools\ replication\ configure publisshing\ agent...

Truncate table will work too.

To delete the merge replication use this script.

sp_replicationdboption @dbname =  'DatabaseName' ,

    @optname =  'merge publish' ,

    @value =  'false'

On my case the program takes a lot of memory m and ussing version 2.0.0 , some times takes 128 MB of memory.

I think you are taiking the incorrect path. Load the file to a folder , shcedule your DTS to run every 1 hour or so, your dts shuld look if...

Correct you may want to look for

sp_repldropcolumn

and

sp_addmergearticle

You may need to have SP3 instaled.

Every time the you create a publication a jobs is created in sql server with this name

[SERVER_NAME]-[DATABASE_NAME]-publ_[PUBL_NAME]

don't you have it on you job list ?

there is an step inside the...

I no sure if the timestamp in java is the same as SQLSERVER timestamp.

in SQL server timestamp is no a date time field. It is used to compare when was...

Same happen to me, installing sp4 may help you.

see this from the MS website.

Preventing False Conflicts

Retention-based meta data clean up prevents non-convergence and silent overwrites of changes at...

beside that , run a nightly job that create the indexs again and update the statictis. To avoid index framentation.

SELECT

* FROM Information_Schema.columns WHERE table_name = 'tbl_states'

replace...