Check for any job that might be causing this. If a job executes a stored procedure, check the stored procedure to see if it change the status of the db.

Agree...

I don't think you need to update stats. I would update stats if I drop and recreate the index with differents columns for example, but if it still remains the...

To run the distrib.exe set the path or run from :

c:\"program files"\"microsoft sql server"\80\com\distrib.exe

But in your sp are you using a cursor to execute any SQL command in the linked server?

I'm using linked servers all the time, and I didn't have any...

You could re create the publication in another server, so when you apply the snapshot generate the sp again, or also execute the stored procedure:

sp_scriptpublicationcustomprocs 'PublicationName'

You must have Service Pack...

What is asking is the name of the SQL Server Instance, you could try adding an alias in the SQL Server client net library.

But check that you can use a...

SQL Server replication changes when needed the replicated tables, but that shouldn't doesn't affect the use of the db. It can add uniqueidentifiers columns, because they are needed in replication.

...

When you set up the log shipping, you must specify a shared forlder in the stand by server, so SQL can put all the logs backup in that folder. You...

You should run sp_help tablename in QA, and check all the data types of the columns. There is one column that is conflicting with the insert. In can be numeric,...

Wich permissions that the user you created has? Is a member of the sysadmin role?

When I say incremental changes, I meant insert, updates and deletes to replicated tables. This can be always the same, or not, it will depend of how much transactions and...

Check the job of the distribution agent in the subscriber, and see the parameters for the distrib.exe command. Check the values -DistributorSecurityMode and -SubscriberSecurityMode. If you autentication mode is SQL,...

Check the estimated execution plan and see if you need new indexes.

you must execute it like this:

if 1=1

begin

EXEC sp_test

end

Are you having errors executing it like this? If so, what error?

It seems that your database is having problems. The maintenance job is runnging a command call DBCC CHECKDB that checks for consistency error in the db. I think that is...