SQL Server 2005 SP2 has an issue with modifying Agent Job's through Management Studio if the @@servername exceeds 30characters For more info on the issue refer http://support.microsoft.com/kb/940269 If you do not wish to apply a hotfix or upgrade...

SQL Server 2005 and later versions expect the service accounts be changed using Configuration manager and not through Services.msc The configuration manager does perform other activities such as adding the service accounts to the Groups and this way...

To be able to view the SQL Server Resource Database A) SQL Server must be started in a Single user Mode Start with -m flag in configuration manager Even if the Server is started in Single user mode, the database will still not be visible in sys...