Use text data filter if your all procedures are using same prefix like 'usp_' or 'stp_'

As per BOL...

You must be a member of the sysadmin role to create and manage maintenance tasks.

declare @jobid sql_variant    

SELECT 

@jobid = convert(sql_variant,

Substring(program_name, charindex('(job ', program_name)+5 , --50)

(charindex(':', program_name)-1 )- (charindex('(job ', program_name)+5))

)

 from master.dbo.sysprocesses   (nolock)

 where spid= @@spid     

SELECT        @jobid

You can shedule this run when sql agent starts instead of every five minutes...because without sql start node is not going to change...

Or you make the procedure to run at...

I don't see any issue with it...

you can use sp_rename proc.

I don't know what cuasing this issue but you can load into a permanent temp table and then copy to the respective tables...

Europe---->Perm.TempTable----->Europe.table.

Asia----->Perm.TempTable---->Asia.table

Who is executing the package?

Check for any security changes...

Did you try restarting sql mail?

Final option will be restarting sql.

Try Updating the status column in distribution.dbo.MSsubscriptions table  to 2..

Status of the subscription:

0 = Inactive

1 = Subscribed

2 = Active

Instead of renaming the PK...you can create the pk dynamically adding the datetime suffix to its name...

DECLARE @sql Varchar(4000)

 , @Date Varchar(20)

SELECT @Date = '_'+Convert(Char(8), getdate(),112)+ Replace( Convert( char(10),getdate(),108),':','')

SELECT @sql =...

You can use SQL Server SMTP Mail XP from sqldev.net...

http://www.sqldev.net/xp/xpsmtp.htm

Scan Density [Best Count:Actual Count].......: 86.25% [2327:2698]

Scan density looks fine to me...

did you DETAIL option when you are running a query to get the fragmentation?

You can only register sql server 2000 servers in EM but you have to have a login (nt/sql) to register irrespective of admin access...

You can't register 2005 servers in EM, you...

If I am not mistaken you can update the system table using DAC connection while system started in single user mode...

I don't think reinstalling sp3 again will cause any damage your dbs...

I did even on cluster servers...

Make sure you have valid backups incase your server crashes while applying sp3...

You cannot configure SQL Server 7.0 master or target servers with SQL Server 2000 SP3 master or target servers.

http://msdn2.microsoft.com/en-US/library/aa213819(SQL.80).aspx