Sai,

You can also accomplish this by using T-SQL 'EXEC msdb.dbo.sp_send_dbmail'

http://technet.microsoft.com/en-us/library/ms190307.aspx

Hope this helps you.

Thanks,

If you are only concerned with the log size space then shrink the log file and not the entire database.

That should take care of the log space.

Thanks!

Switching between recovery models in Production environment may not be possible and re-commended for some customers. Also you could do a smart re-index, where in you rebuild index where fragmentation...

Here's what you can do.

1. Create a new table with the same structure and indexes as the old table.

2. Rename the old table with a different name

3. Rename the...

Here's what i usually do in the SQL Server Job.

1. Open the Job

2. Click Edit on the step that you want to capture the error.

3. Go to Advanced tab

4. Specify...

Great ! Nice and true representation of real life blocking and locking scenario 🙂

This is a new feature in SQL Server 2008.

Yes, we use expressions to form the SQL statements a lot in our ETL process, it's much easier to implement than using parameters, which is messy at a times and...

23 Gigs of data...that's a lot of data to select. I would suggest, fetch selective records using id range in a Loop. You need to code the logic in such...

Use the appropriate batch size parameter in the OLEDB Destination component. In this case it will be 1 million. Also set the Commit size of 1 million. But i would...

First of all you need to include configuration files for each of your packages. Assuming you have that and assuming you keep SSIS packages on FileSystem, copy over the dtsx...

But wouldn't moving large amounts of data over linked server hurt performance? SSIS or BCP would still be efficient. I think the pipe is very limited for data transfer on...

You can also use BCP in/out to transfer data if that's possible. BCP though is not that easy to setup but is usually the faster means of loading data.

You can...

Or you can even build each source-destination as individual SSIS packages and call these from a Main SSIS package as 'Execute Package Task' this way it's more cleaner and can...

Instead of using -n (native) datatype, try using -c (character) datatypes.

Amol