SQL Server Diaries
  • Home
  • About Me
  • Tags
  • Author's home
Navigation bar avatar

SQL Server Diaries


Or How I Did It

Script Logins from Database Users

Posted on March 19, 2011

When performing a database migration from one SQL Server instance to another, the DBA has to transfer all logins which have access to the database.  The transfer will only be successful if the logins retain the same passwords to reduce the impact on the end users, and more specifically, the... [Read More]
Tags: SQL Server 2008 SQL Server 2000 Database Administration T-SQL Programming Security SQL Server 2005 Security

Generate Lottery Ticket Combinations

Posted on March 12, 2011

In Malta, the Super 5 lottery prize has always been considered the peak of winnings by the Maltese.  So much so that it has become part of the day-to-day language when referring to good luck (I feel I just won the Super 5!).  As a challenge, I thought of how... [Read More]
Tags: T-SQL Programming Code Samples T-SQL Programming CTE CROSS JOIN Permutations Combinations SQL Server

Addressing a 'login failed' (Error 18452) error message in SQL Server 2005

Posted on March 5, 2011

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]
Tags: SQL Server Connection Strings Database Administration SQL Server errors Security

Run SQL Server Agent Jobs with Alternate Credentials

Posted on February 26, 2011

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]
Tags: Database Administration SQL Server Integration Services T-SQL Programming SQL Server Agent SSIS SQL Server 2005 Security

Send SQL Server Agent Job log file by Email

Posted on February 19, 2011

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]
Tags: T-SQL Programming SQL Server Agent SQL Server 2005 Database Mail Backup and Recovery Database Administration SQL Server 2008
  • ← Newer Posts
  • Older Posts →
  • RSS
  • Email me
  • GitHub
  • Twitter

Reuben Sultana  •  2021  •  sqlserverdiaries.com

Powered by Beautiful Jekyll