I would strongly suggest not to do a blind reindex. Check and see how fragmented the indexes are and possibly do a defrag instead. If it's 30% fragmented...

I would recommend "Microsoft SQL Server 2005 Unleashed". Any of the unleashed books I have read are very good. It will give you in depth knowledge of SQL...

TargetServersRole already has execute permissions on sp_help_jobschedule.

From my understanding that role only exists in 2005 along with SQLAgentUserRole and SQLAgentReaderRole. I need this role for 2000.

You manually take a backup and restore it to the subscriber. Drop and re-add the subscription and when you re-add the subscription uncheck the initialize button and this allows...