Hey How did you know... were you running the interview! :w00t:

Option 4 is to purchase a third party CDC tool that writes to a remote server from your active log file.

Just putting it out there.

~BOT

Are you saying how can you programmatically check?

because trying to log in with SSMS is probably a good first place to start for most people.

:hehe:

~BOT

If you go with 2, make sure you know what you're getting into. There's a lot going on under the hood with Kerberos delegation. Best to know it very...

Thanks for your help, but I figured it out.

It uses a CTE and row_number() over().

with temp1 as (

select packagename, stepname, dbname, stepstarttime, row_number()

over( partition by packagename, stepname, dbname ...

bcp.exe is a Microsoft-provided utility used to bulk insert data.

Bulk insert is what's going on behind the scenes in the import/export wizard anyway...

There are advantages to bulk inserting data,...

Your plan won't work, but I can offer some advice.

4 million rows isn't tiny, but it isn't that big, either. It shouldnt' take 5-6 hours to load from one...

I have hope that you could use the over() clause, maybe with a WITH() subquery joined in ?

might need a CASE thrown in for good measure.

http://msdn.microsoft.com/en-us/library/ms189461.aspx

you'll need to be far...

Take the backup.

Scripting only generates the DDL (database definition language) that creates the table, not the select/insert/update/deletes that happen.

backup early, backup often, and run a RESTORE VERIFYONLY just to see...

That's WMI.

It's a WQL query you're seeing in the log details, and winmgmt is the WMI service.

checksum() and checksum_agg() and INFORMATION_SCHEMA.COLUMNS

might help you out.

~BOT

VIEW SERVER STATE too.

~BOT

I've dabbled a bit with SB from a custom maintenance job perspective and might have some insight.

What you can do is set up a queue on each server and let...

Like all good answers, it depends...

the copy database wizard uses data pumps and takes longer, if I recall correctly, it also /can/ leave agent jobs hanging around on your production...

Peter,

I think you'll like the next article which is about knowing what is the DBA's responsibility and saying "NO!" to what's contradicts CIA and the systems you have designed...