because the jobs executes the DTS package and it success when is executes.

You should let the DTS package to warn you on error

You could try killing all the users when needed and putting the db in single user mode. But can be dangerous killing all the users. Or also could stop and...

You should be able to eliminate any remote server if it doesn't have any logins specified. You could try removing the logins firts wit hsp_droplinkedsrvlogin or drop the server with...

Sorry, my mistake.

With EM, go up to replication monitor and find the subscription with the error. Right click over it and click in Agent Profile.

Check wich one is SQL using....

Also have the same problem, and is because of a large transaction.

If you have the MaxDeliveredTransactions equal to 0 (wich means all transactions) increase the value to for example 10...

If deleting the 6 mil records, crashes yor server, you could execute the deletes in parts. You could delete the top 1 mil. for example, and then the next mil.

...

You could also check that you do not have duplicate rows before creating your PK with a count and a group by clause for example.

You should schedulle system databases backups, and also backup a database after you change it. For example, if you create a new db, backup the master, if you add an...

Are you sure? I don't use it, and all my sp works just fine.

You could create an sp wich name starts with 'sp_', (just like bultin stored procedures)

in the master. This will let you call the sp from any db, like almost sp...

I think it tried to start the SQL Server Agent at the subscriber. But it coudn't do it because of a login problem. Is the login account used on the...

You could create a cursor like this:

DECLARE @Table AS SYSNAME

DECLARE curTables CURSOR LOCAL FOR

SELECT [name] FROM sysobjects WHERE xtype = 'U'

OPEN curTables

FETCH NEXT FROM curTables INTO @Table

WHILE (@@FETCH_STATUS = 0)

BEGIN

PRINT...

Check in the db options the autogrowth property and also the Mb or % on incremental size. Maybe there is to big and the db size increase to much for...

I would also use DTS packages to export the data that you need. If you want to also replicate the jobs, I would set my production server as a master...

You should be very carefull about this. I would also configure the mail to advice me when the SQL Serve Agent start so I can know everyhing went right. You...