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.

Run the following query. It will generate the script you need. Change to "Result to Text" from "Result to grid" before you run it.

select 'sp_recompile ' + [name] +...

Have you created any indexes to improve the...

Becuase the subject says

select o.name from sys.indexes i

inner join sys.objects o

on o.object_id = i.object_id

where i.index_id = 0