Replication

stored_procedure execution replication on No-sync subscription
is it possible to add stored_procedure execution replication to non- sync transactional replication ? I can't find BOL docs about this. I can add it to the publication but nothing is logged on the distributor when I invoke it. Any thoughts ? ... 18 Aug 2008 17:44

snaphot replication huge log file issue
Hi we have a database at 32 gb which is involved in snapshot replication. On checking log sizes using dbcc sqlperf the log file for this database is 50Gb and is 91% full. I really need to get this database log file shrunk is there anything I should be looking at for the replication to see what the issue is... 25 Aug 2008 05:15

SQL 2000 merge
A customer has a publisher/distributor and one subscriber. Both servers are SQL 2000. This morning, the publisher displayed a message that the snapshot needed to be recreated becuase it was out of date. THe person there answered YES. Now, replication is not working because the error: The process could not d... 20 Aug 2008 09:45

Real time transaction / replication
I need to implement a solution for a company with 2 different locations. One is in Hong Kong and another one is in China. They always need to query the data as fast as possible. So I am thinking placing the same database in both locations. Both databases can be query and updated. I can be more patient on update... 17 Aug 2008 13:03

acheter du achat valium canada cinq on acheter valium en France a vendre pharmacie en ligne us usa acheter du achat valium cinq acheter valium canada soft en ligne
acheter du achat valium canada cinq on acheter valium en France a vendre pharmacie en ligne us usa acheter du achat valium cinq acheter valium canada soft en ligne +++ Anti Inquietude +++ Anti Inquietude +++ Anti Inquietude +++ + + + ACHETER VALIUM BON MARCHE (ALL CARDS ACCEPTED !!!) http://jhku.net/A... 15 Aug 2008 18:13

Replication Monitor: Online Options
Is there any way of allowing users to check their [merge] replication status w/o installing Management Studio? I have MSDE installed on laptops and I would ike my laptop users to be able to check to see if their subscription has been running. (Sometimes the agent does not run according to the schedule after r... 18 Aug 2008 14:38

merge replication: why snapshots are so slow?
Hi All Does anybody know how to improve speed for merge snapshot operation? I was surprised to find that 18g db may take 4- 6 hr to create and apply snapshots. I understand it should take time, but taking into considerations what it does: get ddl, bcp's, apply them... Still takes 2-3 times at least than what i... 16 Aug 2008 09:31

UDFs & Transactional Replication
I created a UDF... create FUNCTION dbo.WhatLocationIsThis() RETURNS numeric AS begin declare @return as numeric SELECT @return = Location FROM storemain..tblLocationTable return @return end GO When I run 'select dbo.WhatLocationIsThis()' it returns the location Next I attempt to use it in a fi... 16 Aug 2008 11:33

generate scrip error
i have transactional replication that is running fine, the problem came out when we neededto move production server. as quick way to create scripts i used generate script wizard. in most cases it worked fine, however for a couple of tables that use procs instead of insert statements i had N'SQl' instead of the ... 26 Aug 2008 11:57

Transactional Replication Subscriber went missing after Timeout
I have Transactional Replication from one of the databases out to a reporting environment (both SQL 2000 SP4). I have a transactional database which is the publisher (where I have the distribution database) and replicating out to a reporting environment (Push subscription from the publisher). All of a sudden, ... 15 Aug 2008 23:20