Issue with @@SERVERNAME exceeding 30characters

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 to later service packs. You can also decrease the size of  the server name if standalone and use SP_DROPServer  to remove…

0

How to view the contents of SQL Server Resource Database

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.databases view Open the database with the use command USE mssqlsystemresource…

1