SQL Server Diaries

An excellent article posted by Il-Sung Lee (Program Manager, SQL Server Protocols) at Understanding “login failed” (Error 18456) error messages in SQL Server 2005 describes the various error message severity levels. [Read More]

According to the Selecting an Account for the SQL Server Agent Service, the SQL Server Agent service account should be able to authenticate with the instance and also be a memeber of the sysadmin fixed server role. [Read More]

When creating an SQL Server Agent job with one or more steps, each step can be configured to write the query output to a log file.  If the job failes, such a log can assist a DBA identify the cause of the failure.  That is, if the log is still... [Read More]

Accurate documentation is paramount for any system. Unfotunately, when developing a database we sometimes tend to overlook this particular document. [Read More]

When migrating databases from SQL Server 7 or 2000 to SQL Server 2005/2008 the steps can be summarised as follows: [Read More]