What's the load on the production side v the DW side? If you are going to exceed the sum of the CPU usage, you might have an issue.

For memory it's...

The job is successful. It runs without an error.

The execute process task will do better. The other thing you can do is "Raiserror" and that can cause a failure.

I'm not completely clear here. When you say logon, do you mean connect to SQL Server or log on to the physical console of the server?

If you mean when the...

Actually if you use a third party tool I don't think it's too bad reading the log. Lumigent, Red Gate, ApexSQL, Golden Gate all have tools that work well.

The...

Lowell,

Thanks and we'll look at implementing this.

Steve

Not really. It was my mistake in the first place

Must have been one of those early morning or late night questions.

Points have been awarded back and the question corrected.

I've written about this before, but for most DBAs I've talked with, the cube/dimension/measure concepts are not something they understand. It's a huge leap of understanding to go from the...

Besides the DTS articles here, you might try http://www.sqldts.com as well.

Not sure what happened there. Looks like someone submitted a script with a link to a bad image file. We'vee removed it.

Tried 4guysfromrolla.com?

Avatars sometimes don't work. If it doesn't, send it to webmaster at ssc.com along with your email and we'll get it uploaded.

Rog,

Seems like you're on the right track here and with the advice from Colin and Gila.

First I'd tell the acting DBAs that database size has nothing to do with log...

You can batch things like this:

http://www.sqlservercentral.com/columnists/sjones/batching.asp