FIX: You must restart the SQL Server service on the principal server after you resume the SQL Server service process from a debug tool in SQL Server 2005
The following pages were recently modified.
Source: Knowledge Base
Product: Microsoft SQL Server 2005 Enterprise Edition
Notification Contents: New and Major Modifications
FIX: You must restart the SQL Server service on the principal server after you resume the SQL Server service process from a debug tool in SQL Server 2005
http://support.microsoft.com/kb/943389/en-US