see other post. Pls do not cross post. We check all the forums for new messages.

Steve Jones

steve@dkranch.net

Thanks for the followup. Hope you enjoyed your holiday.

Steve Jones

steve@dkranch.net

Check the DTC service on both machines. The account may need rights for the other domain.

Steve Jones

steve@dkranch.net

They should resolve to the same thing, but the view actually will be precompiled. My method and Andy's should be about the same. This assumes that the view is created...

Use SET ROWCOUNT @n

before the select and

SET ROWCOUNT 0 after.

Steve Jones

steve@dkranch.net

Datediff gives the number of weeks. based on the current day, you can calculate wheterh there are 4 or 5 fridays. Take a few minutes and work it on paper,...

A few things. If the first part is sequential, you can store this in a global variable and retrieve it before the task and update it after (2 dyn tasks).

Also...

Yes

No

Can't tell right now

check back later

outlook not clear

is would seem so

take your pick

Steve Jones

steve@dkranch.net

That may or may not work. Sometimes the log file will not shrink because there are no full virtual files within the log. The script above will handle that.

Steve Jones

steve@dkranch.net

I agree with Nigel. Start logging the steps and then you can find where the issue is.

Steve Jones

steve@dkranch.net

Wow!!! sounds like a lot of work.

I'm not sure of the problem and I guess MS thinks that adding up all the step times should be the total time.

Personally, when...

I'd think DTS could do this, but never tried. Actually, if you are moving from varchar to nvarchar, this should automatically do this.

Steve Jones

steve@dkranch.net

np, sorry I can't provide better info.

Steve Jones

steve@dkranch.net

I am assuming that dbcc Shrinkdb is not making the log file smaller, right? Or is an error occurring?

If the log is not shrinking, it may be because the partitions...

You're welcome and thanks for the followup. BTW, where did you find this?

Steve Jones

steve@dkranch.net