Maybe you should consider SSIS to copy data between databases. You can transfer other objects also if, for example, you want to transfer stored procedures.

I'm not sure what you mean by a batch, but if you want to for a particular task, open Disconnected Edit in the package by selecting it from the Package...

select U.name as username,

O.name as object,

permission_name as permission

from sys.database_permissions

...

You could use an activeX script in the workflow properties of the first task in the package to check the current date and report a failure which would stop the...

I can't speak to the example shown in the Select Login box. All I know is that when I click the browse button, I don't see any groups, only...

Since tlog backups back up transactions since the last full or log backup, you could delete any of the differential backups and still be able to recover to a point...

A domain group cannot own a job. That's why, in your first example, Domain\user1 was listed as the owner of the job he created. Group membership allows an...

Hi Mahesh,

To have a step join the package transaction: in a addition to checking Use transactions, you must also select the Join transaction if present checkbox in the workflow properties...

What type of backups are the hourly backups? Full, differential, log?

If I understand, you now have backup sets for three databases in one backup file. You can choose...

You'll use branching workflow. The "on success" workflow leads to the next sequential step and the "on error" workflow leads to the Send Mail task. You can use...

I think Oracle Data Pump is closer to DTS than Warehouse Builder (which includes modeling and metadata management).

I'm not sure I understand your question. Do you want the package to send an email and stop package execution if a task fails?

If so, then have an "On...

Lowell (9/28/2009)[hroops...the Default Trace tracks DDL changes(CREATE OBJECT,ALTER,DROP) , not insert/updates. you'll want to add a seperate server side trace that captures SQL:BatchCompleted events and , and query that, but...

You'd install another instance the same way you installed the existing one. Enter a unique instance name when prompted by setup. Database components will be designated with a...

You could also query the log file written by the default trace, a background trace that runs in SQL 2005. See "Default Trace" in BOL or search this site...