Thanks Guys... I guess I know whats happening now.

I think I'm hitting the limit on maximum number for continuous subscriptions on a distribution server.

I am planning to setup scheduled subscriptions

Shinoj

Any thought experts ?

You can select it this way and insert it into a table

SELECT COALESCE(@HostNames + ',', '') + host_name

, COALESCE(@LoginNames + ',', '') + login_name

FROM sys.dm_exec_sessions

WHERE

program_name LIKE '%Management...

SELECT OBJECT_SCHEMA_NAME(P.object_id), P.* FROM sys.partitions AS P

You may have more than one row for a table in the output - This is based on the number of indexes on the...

But why do you need this. As far as your TLog backup is done by log shipping you should be good right ?

Why would you need a Maintenance Plan and...

To remove a DB from StandBy/ReadOnly mode to a Read/Write mode, you can use the following syntax

RESTORE DATABASE <DB Name> WITH RECOVERY

Is this what you need?

How many subplans do you have? Just One?

Can you view the history for the job in the Maintenance Plan? Right click on the job (under SQL Server Agent/Jobs) and View History?

Also check the "Limit size of job...

Do you think you could use the shared path instead of the mapped drive letter in your jobs?

Is your broker enabled on msdb database?

SELECT is_broker_enabled, name FROM sys.databases

If not use the Alter Database command to do so. You might have to stop the agent service to do...