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 Failure.

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