I created a UDF...
create FUNCTION dbo.WhatLocationIsThis() RETURNS numeric AS
begin
 declare @return as numeric

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 ...

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

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

We have 2 databases ( publisher / subscriber ) participating in a
transactional replication arrangement ( 1-way ).
It's been (probably) months since we have had to fix a problem by
reinitializing a subscription between the two.

I am a SQL novice and this is my 1st time using replication. I'm using merge
replication to publish on sever 2005 and pull subscribers using express 2005.
All seemed great, until I could not longer add items to a particular table on
the publisher. It gave an error stating I ...

Configruation:
Main SQL Server - SQL 2005
Remote SQL Servers  SQL 2000 & 2005
I am looking to setup a partitioned transactional publication from my

Is there anyway to stop delete transaction from being replicated to the
replicated server. Using SQl Server 2005 transactional replication

Hello, I'm using merge replication between SQL Server 2000 and MSDE. How can
I do when I need to make some changes in my db structure like:
* Add. Drop or Alter column
* Add Drop or Alter restriction (FK, PK)

I was going through analysys of missing indexes. I ran some queries from BOL
on
sys.dm_db_missing_index_group_stats and sys.dm_db_missing_index_groups to
find out which columns would benefit from index creation.

Merge replication 2005
if i have one publication with 200 articles or 4 publications with 50
articles each - will there be any noticable speed difference between
those two options?

Hi @ all,
i'm trying to setup an transactional replication witch actualisable
subscibers (push)between two MS SQL Server 2005 Enterprise. Working on two MS
Server 2003 RC2 each on virtual machines.

Trying to test out Precomputed Partitions.  Publisher is SQL Server 2005 SP2
Standard Edition, subscriber is  Express SP2.
I set this on the articles and ran the snapshot.
Now when I try to run the Subscriber (doesn't matter if I tell it to

We have snapshots failing to take; i.e. the bcop process goes, then indexes
are applied, some transactions are applied (the snapshot being concurrent)
and then the whole process starts over again - ad infinitum.
Enabling verbose logging etc I found the error: ODBC/OleDB error: ...

I am looking forward to help regarding a very strange thing here.
Environment: Windows 2K3 + SQL Server 2K5 + each server is two-node
Active/Passive clustered box
I have a replication scenario here: