all groups > sql server replication > august 2003 > threads for august 29 - 31, 2003
Filter by week: 1 2 3 4 5
DB from SQL Standard to SQL Desktop Engine
Posted by Michael Lee at 8/31/2003 5:40:56 PM
Is there a way to convert/copy a DB created within SQL
Server 2000 Standard edition to SQL Server 2000 Desktop
Engine? This needs to be done to connect the database to
Visual Basic.Net which doesn't support connections to the
standard edition of SQL.... more >>
cant see all dist agents in perfmon
Posted by Hassan at 8/30/2003 1:55:59 PM
I have some publications with many subscriptions as part of transactional
replication.
Why cant i see all those distribution agents in the perfmon counters for SQL
Server: Replication Dist object under instances ? I see just 2 out of the 20
or more that we have . I am using SQL server 2000
... more >>
restarting replication after it barfs
Posted by chris at 8/30/2003 12:41:08 AM
sql2k sp3
I have replication successfully working on a number of tables. Someone tried
to insert a null value where they shouldnt have. I get the message:
Cannot insert the value NULL into column 'cr_username', table
'adv084dk2.dbo.current_run_cr'; column does not allow nulls. INSERT fails.
(... more >>
Distibutor Agent Error
Posted by Johann Castueras at 8/29/2003 12:28:39 PM
I have setup a Transactional replication (two SQL 2K, SP3 running Win2K).
When I try to run the distribution agent, i get this error:
Error Message : Line 29: Incorrect syntax near 'UPDATE STATISTICS '.
Error Details : Line 29: Incorrect syntax near 'UPDATE STATISTICS '.
(Source: IP Addres... more >>
Distribution dog slow
Posted by captainkt at 8/29/2003 9:54:29 AM
My distribution agent is running really slow, and I can't
figure out why. I have the publisher and the distributor
on the same server, and I am only subscribing to one other
server. My log reader is putting about 904 cmds/sec into
the distribution database, while the distribution agent is ... more >>
snapshot problem
Posted by s at 8/29/2003 6:35:17 AM
I'm getting this message "The initial snapshot for
publication 'mydb' is not yet available" from the
distribution agent. What does this mean.... more >>
|