August, 2008

  • Vijay

    How to view the contents of SQL Server Resource Database

    • 1 Comments
    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...
  • Vijay

    SQL Server Group accounts

    • 1 Comments
    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...
  • Vijay

    Issue with @@SERVERNAME exceeding 30characters

    • 0 Comments
    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...
Page 1 of 1 (3 items)