How to Configure Mail Alerts for SQL Server Job Failures

Alerting  the Admin for SQL Server Scheduled Job failure involves the following Configurations ==> Configure Database Mail. ==> Create a SQL Server job. ==> Configure Alert system in SQL Server Agent properties ==> Create an Operator. ==> Adjust the SQL Server job to send on Failur...

Read more

How to import data using import and export wizard in SQL Server

Step-1: Open SQL Server Management Studio, connect to an instance. Step-2: Expand databases & select the respective database to initiate the import process. Step-3: Right click on that database and click on Import data. And then click "Next...

Read more