Do you mean "Log Shipping"?

1) select * from master..sysprocesses where blocked > 1 and waittime > xxx

2) Scheduling a job is required.

3) Ignore self blocking (blocking by same SPID)

sp_publication_validation

Yes, I was just refering to the ability to bookmark a page/topic and nothing else.

I think reinstalling the instance will create new MSDB database. So old SQL Server Agent jobs, alerts, SSIS packages, etc. will not be available.

"Help Favorites" feature is available.

It is very important to understand execution plan.

To start with, visit http://msdn.microsoft.com/en-us/library/ms979196.aspx

I think the password of SQL Server Agent service logon account has been changed.

I agree 100% with Jack Corbett

Grow your current position by getting your current employer to upgrade to SQL Server, even if it is Express edition from Access. Then you...

Change the recovery model to BULK_LOGGED just before reindexing.

After reindexing, revert to FULL.

Yes. Replication replicates schema changes as well.

Thanks Adrian for replying.

This issue has been resolved. It was happening due to difference in the UDDTs in the publisher and subscriber.

How many arguments are you passing when you run this stored procedure?

This stored procedures accepts only one arguments.

How did you try to modify the table? Using GUI or ALTER TABLE command?

Try ALTER TABLE command.

Otherwise, temporarily remove this table from...

Create a scheduled job using SQL Server Agent.