Declare @sqlCommand nvarchar(max)

, @recipients varchar(max) = '{your email address here}';

Declare @body nvarchar(max) = 'This File created on: ' + convert(char(10), @startDate, 121);

...

SQL Server Data Tools is a freely available download for SQL Server - you don't need Integration Services to create and execute packages within the development tool.

You do need Integration...

patilpallavi16 (9/13/2016)

---

Actually I want to write a sql script rather than use SSIS package. And the requirement is to output a text file with the give specs.

I just gave...

When you run a batch file - or powershell script - from the task scheduler you have to identify what account the task scheduler job will use. This needs...

If you setup a read-only replica in an Availability Group - you will also have orphaned users in the databases that are setup for read-only access. For windows users...

SQL Server Agent should be using Database Mail - which uses sp_send_dbmail. You don't need to intercept anything...instead of checking the box to notify the operators, you just create...

If your SAN is a Compellent - and you are backing up to the same file, then it could be that file is getting dropped to the lowest tier on...

Hugo Kornelis (3/2/2016)

---

The alternative, since this appears to be some type of ETL process to feed a DW table, would be to create an SSIS package.

That tool is specifically built...

If your log has stabilized at 3GB - and was grown out in 512MB chunks - I don't see any problems here that need to be addressed. You have...

You need to run an integrity check on that database:

DBCC CHECKDB(ETL) WITH NO_INFOMSGS, ALL_ERRORMSGS;

Review the results (and post the errors here if needed) to figure out what your next options...

If your network latency between prod and UAT is too high - the restore process could fail, not to mention the fact that you will be using the network on...

This can somewhat be automated using SQLCMD or Powershell. If you can setup contained databases it is much easier to just create the user in the database and let...

One advantage of the third-party tools is the ability to stripe the backups into a single-compressed file. Striping this way can reduce the time it takes to actually perform...

When looking for these 'special' accounts - you have to specify the local system and search for 'nt service\mssql'. Once you do that they will show up and you...

Since that drive is dedicated to tempdb - why are you concerned with recovering disk space? Let it use what it needs...

As for the objects - do you have...