Viewing 15 posts - 16 through 30 (of 41 total)
In some cases, the columns to be indexed disregarded the column names. For exampe, I have columns named with an underscore....these were parsed as separate column names. And,...
October 20, 2009 at 2:54 pm
The create index syntax appears flawed as well. There are several occurrences where the column names are not parsed correctly. It does create a good result set to...
October 20, 2009 at 9:08 am
Thanks for the revised code. I've added the following to proc_FilltblIndexUsageInfo:
where
so.type = 'u'
and...
October 20, 2009 at 8:06 am
Agreed. Also, index reorgs can somtimes wreak havoc with TL shipping. I haven't had the chance to completely finish these scripts due to time constraints. Is anybody...
October 20, 2009 at 7:39 am
I was just trying to figure this out and I came across your post. Here's the solution that worked for me:
DTSRun /S"Server" /N"Package Name" /E
The tilde (~)...
September 2, 2008 at 12:36 pm
No, they're all named UP_ I actually have a total of three. All start with the prefix UP_. One of the three gets categorized correctly. Basically,...
June 19, 2008 at 12:07 pm
paul.ibison (3/6/2008)
all due respect but I think you're missing the point.
Judging by some of the questions, some others (Jeff apart) have also never really tried to solve this problem...
March 6, 2008 at 1:07 pm
admin (3/5/2008)
I've found that the...
March 5, 2008 at 9:02 am
paul.ibison (3/5/2008)
March 5, 2008 at 8:15 am
Laura Meyerovich (3/5/2008)
March 5, 2008 at 7:58 am
I think a combination of omitting the first row and doing a conditional split would do just fine. This the method I use since I receive a number of...
March 5, 2008 at 7:01 am
For future reference, you may want to consider doing what I do when deleting a considerable amount of archived data. I create a temporary table where I store the values...
January 7, 2005 at 8:59 am
That was the issue. The n' prefixes on the second line were also not necessary, I realized this after I posted.
March 1, 2004 at 6:39 am
Problem appears solved. The developer is using JBDC and another person in our department researched that angle and came up with this solution link:
February 27, 2004 at 6:47 am
Viewing 15 posts - 16 through 30 (of 41 total)