You don't seem to returning the @ret from the stored procedure...with or without the raiserror your stored procedure will not return anything...

maybe something like this?

CREATE PROCEDURE sp1(@ret varchar(100) output)

AS

BEGIN

BEGIN TRY

SELECT...

Maybe this -> http://serverfault.com/questions/147459/cannot-perform-a-differential-backup-for-database-mydb-because-a-current-data

Gowtham Chowdary (10/6/2010)

---

if you say that point in time is not nessasary to resume the replication. then i will change my DR stratagy and switch the Distribution database to simple...

The snapshot will be generated for all articles being replicated (i.e. all the existing articles plus any new articles being added to the publication) - however the distribution agent will...

Adding/Dropping articles from existing publications: http://technet.microsoft.com/en-us/library/ms152493(SQL.90).aspx

When you are generating the snapshot you will be able to access both the publisher and subscriber - from what I remember the snapshot agent...

What's the error you're seeing?

You can use this procedure http://www.sqlservercentral.com/scripts/Print/63240/ to print out your data in chunks of 8000...I've used it in the past to debug dynamic SQL statements that way exceed 8000 characters...

Same code snippet as above - using sp_executesql and parameters...this uses the same type of comparison used in your SP code (appending a % for the like comparison) and it...

For some reason I'm unable to view the code you pasted...however the sample WHERE clause you posted seems to have some issues...I've put in some sample code below modifying the...

Use the SP available here http://www.sqlservercentral.com/scripts/Print/63240/ to print out your variable in chunks of 8000 characters.

DECLARE @max-2 varchar(max);

SET @max-2 = REPLICATE('X',8000);

SET @max-2 =

Are you moving the DBs to another location on the same server or to different servers?

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/04/27/how-to-move-publication-database-and-distribution-database-to-a-different-location.aspx talks about how to move the distribution (and publication DB) to a new location...

[edit]: Looks like this is answered in the original thread http://www.sqlservercentral.com/Forums/Topic996602-391-1.aspx

I've never seen this error but the documentation states that this happens due to workload on the server

http://msdn.microsoft.com/en-us/library/aa337448.aspx

The only "resolution"...

Replication will support schema changes if you set the replicate_ddl flag when setting up the publication - no need to stop and start replication to replicate schema changes from the...

BOL has some good information:

http://msdn.microsoft.com/en-us/library/ms151866.aspx - "Configuring, Modifying, and Disabling Publishing and Distribution" - provides steps on how to do this using T-SQL, RMO and SSMS

http://msdn.microsoft.com/en-us/library/ms152503(v=SQL.100).aspx - "Creating, Modifying, and...

Under what conditions do you see this error? i.e. do you know which query is triggering this error?

Check http://support.microsoft.com/kb/288095 to see if something similar is the cause. This error also...