Viewing 15 posts - 38,971 through 38,985 (of 39,901 total)
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,...
December 24, 2001 at 7:41 pm
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...
December 24, 2001 at 7:40 pm
Yes
No
Can't tell right now
check back later
outlook not clear
is would seem so
take your pick
Steve Jones
December 24, 2001 at 11:33 am
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
December 24, 2001 at 11:30 am
I agree with Nigel. Start logging the steps and then you can find where the issue is.
Steve Jones
December 24, 2001 at 11:26 am
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...
December 21, 2001 at 10:12 pm
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
December 21, 2001 at 4:33 pm
December 21, 2001 at 12:06 pm
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...
December 21, 2001 at 12:03 pm
You're welcome and thanks for the followup. BTW, where did you find this?
Steve Jones
December 21, 2001 at 11:56 am
December 21, 2001 at 10:41 am
Well, I had a short chat session with nasir afridi and here is some followup:
The DDL for the table:
if exists (select * from sysobjects where id = object_id(N'[dbo].[ProductOwnerInfo]') and OBJECTPROPERTY(id,...
December 21, 2001 at 10:36 am
Sorry, not really an Oracle guy. I'd start with Oracle, my company (www.iqdestination.com) also has some lower cost e-Learning options. Some of the other guys here have Oracle systems, maybe...
December 21, 2001 at 10:32 am
December 21, 2001 at 10:26 am
December 21, 2001 at 10:25 am
Viewing 15 posts - 38,971 through 38,985 (of 39,901 total)