UDFs & Transactional Replication
Thu, 14 Aug 2008 14:37:26 -0700 (PDT)
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 ...
|
generate scrip error
Thu, 14 Aug 2008 12:31:01 -0700
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 t ...
|
Transactional Replication Subscriber went missing after Timeout
Thu, 14 Aug 2008 10:10:14 -0700 (PDT)
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 sudde ...
|
backup/restore help
Thu, 14 Aug 2008 07:47:40 -0700
i am having issues w/ merge with one publisher and 2 subscribers. the
subscribers are not replicating and i can't seem to figure out why. the
servers are sql 2005 sp2 for everything except the analysis services.
So, i am thinking about removing sql and then re-installing.
BUT, i need the data on the subscrib ...
|
replication monitor not correct
Thu, 14 Aug 2008 06:48:39 -0700
Merge replication w/ 2005.
I have updated the distributor and 2 subscribers to SQL 2005 SP2 - the
update on the subscribers failed for only Analysis Services - all other
updates were fine.
I have changed the merge agent job properties to have -Output and
-OutputVerboseLevel 2 and the output file has text fo ...
|
How to Run Snapshot Agent in Query Analyzer
Wed, 13 Aug 2008 22:46:01 -0700
my transactional snapshot agent is failing with "Server Execution Failed" and
"No Response in the last 10 minutes" I read in another post that I should try
to run the Snapshot agent in Query Analyzer so I can get a more useful
output. It sounds like great idea, but I don't know who to do it. The post
didn't ...
|
Urgent problem with Merge Replication
Wed, 13 Aug 2008 08:52:18 -0700 (PDT)
Hi,
We are running merge replication and yesterday I moved the publisher
from ServerA to ServerB, I recreated replication to ServerC as a
subscriber and ran some testing and everything seemed ok.
Coming into the office this morning I have found the following
message:
The schema definition of base table ' ...
|
|
|
Changing an article from download-only to bi-directional
Wed, 13 Aug 2008 07:01:05 -0700 (PDT)
I have a merge replication set up and I need to change one of the
articles from download only to bi-directional. I tried doing this
through SSMS and marked subscriptions for reinitialisation and
recreated the snapshot. However, when I tried to synchronise I got
errors:
"The merge process failed because it dete ...
|
Transaction Replication from SQL 2005 / 2008 to MySQL
Wed, 13 Aug 2008 04:10:01 -0700 (PDT)
Hey,
I've been investigating the possible way of getting transactional
replication from SQL 2005 or now SQL 2008 to MySQL working, and have
not been able to do this. In SQL 2000 I was able to get this up and
runnign but there was a documented problem when the distribution
agents restarted it would fall over, ...
|
Subscribers are no longer getting all update applied at the Publisher
Tue, 12 Aug 2008 17:01:36 -0700 (PDT)
Some of the database updates on the Publisher are not being downloaded
to the Subscriber. However, all the changes at the subscribers are
being uploaded successfully to the Publisher. But, when I do a
complete download to a new local database I get all the data from the
Publisher. We've been running live for ...
|
