Am I missing something? ...

ALTER TABLE MyTable

ADD NewZip char(10) NULL DEFAULT 'Zipcode' WITH VALUES

you can simply set the partitions "ahead-of-time" and they will only be populated when the data gets there. So you could plan for say 7 years and let the ball...

you need to update the "originating_server" column of the jobs that were already there ( on msdb)

All I was trying to say is that with a SELECT statement you *can* import your AS400 data. How you do it, is up to you. But it is...

if you create a Linked server to AS400 (which can be done) all you call ETL is a "SIMPLE" select query

Cheers,

ALZDBA,

Thanks! I haven't had the time to play enough with the encryption stuff latetly so I do appreciate your comments.

Michelle is right. I left the spid out for you to "fill in the blanks"

Cheers,

Tell me about it!!!

BOL 2000 vs. BOL 2005 seems like the Bible vs Mickey Mouse adventures

Hopefully your tables are *really small* that implemetation could not get off the ground on one of my tables

Cheers,

You just nailed it. It is a very poor design. But those are the requests we get most of the time.

You got my attention too.

Only three questions and you know who's who?

-Can you elaborate ?

Great Article! Simple through examples and very clear.

Keep'em comming

Cheers,

Short answer: you don't. That, is totally internal and is being handled by undocumented functions.

Again the premise is not to loop the above is "looping"

I don't think there is an efficient way of solving this problem SET-BASED...

I agree with Grant. I have to see the queries.