I might be missing something - but why would you want to migrate data?

I'm assuming you are talking about an approach similar to this -> http://www.b4pjs.co.uk/archive/2011/04/using-dynamically-created-partitioned-views/

Edit: Looks like my...

Also, I noticed that we need to recreate the snapshot whenever we make the change to the article (i.e when I enabled articles to not replicate deletes). It forces me...

I'm not sure about the behaviour.

From this link:

Problem 2: Updates to Primary Keys

1) Every row updated on the publisher can also generate...

Information on how to configure articles to not replicate deletes - http://www.sqlservercentral.com/articles/Replication/3202/

Regarding deferred updates - as mentioned in the link these happen for updates to the primary key and I...

The links below have sample scripts on how to encrypt data in SQL Server 2005:

http://blogs.msdn.com/b/lcris/archive/2005/06/09/simple-demo-for-how-to-encrypt-and-decrypt-a-table-column-in-sql-server-2005.aspx

http://blogs.msdn.com/b/lcris/archive/2005/06/10/sql-server-2005-column-encryption-demo-part-2.aspx

http://blogs.msdn.com/b/lcris/archive/2005/12/16/sql-server-2005-yet-another-column-encryption-demo-quot-clinic-quot.aspx

How about modifying the procedure that returns the look up information to update a column if a match is found?

For e.g. something like

SELECT <...> FROM Table WHERE Criteria = @Criteria

IF...

Hakuna Matata :):):) (7/8/2011)

When I use this in a select statement as shown i get Sql Server

declare @Str1 varchar(32)

declare @Str2 varchar(32)

select @str1='Sql', @Str2='Server'

select @str1 + char(13) + @str2

Am I doing...

Adapted from one of the methods explained in this[/url] article:

DECLARE @TABLE TABLE (fldName1 VARCHAR(8), fldName2 VARCHAR(8))

INSERT INTO @TABLE(fldName1,fldName2)

SELECT 'Test1','Name1' UNION ALL

SELECT 'Test1','Name2' UNION ALL

SELECT 'Test2','Name1' UNION ALL

SELECT 'Test3','Name1' UNION ALL

SELECT...

One way of doing this would be to modify the article properties to not replicate deletes.

But if you need this behaviour for only a short period of time you'll...

That's a limitation of the PRINT command - from BOL:

A message string can be up to 8,000 characters long if it is a non-Unicode string, and 4,000 characters long if...

You can post this as an issue on connect.microsoft.com and hopefully someone from Microsoft will look into this and verify if it is indeed an issue - and hopefully also...

ah well - it was a good theory while it lasted - I can go "hmm...interesting" again 😉

If you think the issue is with the sp_MSmaximum_cleanup_seqno SP then use the...

Have you looked at the separation of duties framework at http://sqlserversod.codeplex.com/?

Might not be exactly what you are looking for but it seems to be a better way of managing...

Can you run the following on your distributor DB and check if the snapshot publication has got immediate_sync set to 1? The transactional publication should be default have this set...

I believe that we've determined that sp_replicationdboption removes the distribution and snapshot jobs and the data in the distribution database associated with publications, though I'm not the person who tested...