Viewing 15 posts - 16 through 30 (of 45 total)
siz if you want more performance use this in your group by and select
dateadd
(d,datediff(d,0
November 3, 2006 at 7:01 am
Hi lance can you tell me on wich roles this user is included ?
October 26, 2006 at 10:57 am
If the result from the query is a value (No a table) you can use something like this.
DECLARE
nvarchar(2000
October 25, 2006 at 8:20 am
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...
October 10, 2006 at 12:50 pm
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...
September 14, 2006 at 7:03 am
August 10, 2006 at 8:23 am
To delete the merge replication use this script.
sp_replicationdboption @dbname = 'DatabaseName' ,
@optname = 'merge publish' ,
@value = 'false'
August 10, 2006 at 8:21 am
On my case the program takes a lot of memory m and ussing version 2.0.0 , some times takes 128 MB of memory.
July 18, 2006 at 9:23 am
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...
July 13, 2006 at 10:33 am
Correct you may want to look for
sp_repldropcolumn
and
sp_addmergearticle
You may need to have SP3 instaled.
July 12, 2006 at 1:47 pm
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...
July 12, 2006 at 1:45 pm
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...
July 11, 2006 at 10:25 am
Same happen to me, installing sp4 may help you.
see this from the MS website.
Retention-based meta data clean up prevents non-convergence and silent overwrites of changes at...
July 11, 2006 at 10:17 am
beside that , run a nightly job that create the indexs again and update the statictis. To avoid index framentation.
June 22, 2006 at 2:37 pm
SELECT
* FROM Information_Schema.columns WHERE table_name = 'tbl_states'
replace...
June 20, 2006 at 10:20 am
Viewing 15 posts - 16 through 30 (of 45 total)