any thought guys ?

Any Thoughts ?

Dito..... METADATA OUT OF SYNC... worked

But why would it? Do you have any articles..

Thanks for your help

Shinoj

What version & build of SQL Server is this?

- Microsoft SQL Server 2008 R2 (SP1) (Build 7601: Service Pack 1)

Have you run a DBCC check on the database, or...

Well if you are looking for a three part name in the command text, I guess this will be only in the command column in jobsteps

Are you opening up SQL Server 2005 Configuration Manager for sure?

SELECT database_name, * FROM msdb.dbo.sysjobsteps

Have you thought of Transactional Replication

Was logshipping set up on this DB?

Perfect - Mine is a 8CPU server

And

select COUNT(*) from msdb.dbo.sysjobs sj join msdb.dbo.syscategories sc on sc.category_id = sj.category_id

where sc.name = 'REPL-Distribution'

is just 27

Still not figured why... but thanks for all...

distributor_admin is a sysadmin. I guess that's why the use is not in sysproxylogin

1)

select * from MSdistribution_agents

17 and 12 form two distribution agents a toal of 29

2) checked all the publications and all are using independent agent (column value is 1)

3) also...

My subsystem table has these value, seems high and I hardly have abt 10 publishers and about 20 subscribers. I wonder how I hit a limit

Snapshot - 800

LogReader...

Thanks roy..

I sort of messed up the whole thing when i did it last time...

I restarted the distributor without stopping the logreader agents and after the service came back...

I have only about 10 publishers and 20 subscriptions in all but I kept hitting the limit

as I start the snapshot agent after creating new publication and subscription.

I delete...