Database Solutions

How to Create SQL Server Database Mail on Multiple Servers

SQL Server's Database mail can never be skipped as it is very important and has to be enabled to send notifications to end users. Setting database mail on a single server is not a tough task as it can be easily completed using the SQL Server management studio. However, it will be a hectic task if you are setting SQL Server Database mail on hundreds of server. Use this script to automate it. Create Table The very first step in this automation is to create a table to hold server names. Create...

Read more »

How to Check Database Integrity and Identify Corrupt Databases Automatically via Script

It is common that DBAs use SQL Server's Maintenance plan to check the integrity of databases. If the maintenance plan fails during execution, it is understood that one or many databases have failed the integrity check. The DBA then has to check the SQL log or Maintenance plan's Execution history to identify the corrupted database. The below script will send info about corrupted databases so that a DBA can directly work on the repair rather than wasting time in identifying which database was...

Read more »

3 Possible Vulnerabilities and Solutions in SQL Server Email

In this article we look at the vulnerabilities associated with enabling SQL Mail and look at ways to work around such security issues For SQL users, enabling an email database for replying to database queries is possible, since queries are handled by the database itself. However a minimum requirement for activating an email database in the application is to run SQL Server with a domain account having access to local admin privileges. However one of the drawbacks of using mail activated SQL...

Read more »