Field Mapping

Error message when you restore or attach an msdb database or when you change the syssubsystems table in SQL Server 2005: "Subsystem % could not be loaded" "The Snapshot subsystem failed to load" SYMPTOMS loadTOCNode(1, 'symptoms'); Consider the following scenario. You perform one of the following actions in Microsoft SQL Server 2005: • You restore an msdb backup. • You attach an msdb database. • You change the information in the syssubsystems table in the msdb database. Solution: 1. In SQL Server Management Studio, run the following script.use msdb go delete from msdb.dbo.syssubsystems exec msdb.dbo.sp_verify_subsystems 1 go 2. Stop and then restart the SQL Server Agent service.

By default, the following schema changes made at a Publisher running SQL Server are replicated to all SQL Server Subscribers: ALTER TABLE ALTER VIEW ALTER PROCEDURE ALTER FUNCTION ALTER TRIGGER If you do not want to replicate schema changes for a publication, disable the replication of schema changes in the Publication Properties - dialog box. For more information about accessing this dialog box, see How to: View and Modify Publication and Article Properties (SQL Server Management Studio) . To disable replication of schema changes On the Subscription Options page of the Publication Properties - dialog box, set the value of the Replicate schema changes property to False. Click OK. To propagate only specific schema changes, set the property to True before a schema change, and then set it to False after the change is made. Conversely, to propagate most schema changes, but not a given change, set the property to False before the schema change, and then set it to True after the change is ...