Just try to put the question in the appropriate topic when you can, makes it easiers for others to find.

Andy

Please post questions in the appropriate forums (DTS). Not all readers check all open discussions, you're much more likely to get a good answer if you post in the right...

A good discussion question!

My vote:

1) Char 7. Though Im bad about using varchar anyway.

2) Depends on whether I'd be translating it or not..or how often. In other words if the...

I doubt Access is the issue - thought it does have its own query specific timeouts you can adjust if you're running something long - but its better to drive...

Does make sense. We'll look at it, depends on how Brian implemented the scripts I think how much time it'll take (and when we can find it!). Thanks for the...

MSDB defaults to simple mode - have you changed it to a mode that retains the tlogs?

Andy

I know of no limit to how many records you can address - other than when you just run out of disk space to hold them!

Operations involving 700k records are...

Which SQL version?

Andy

Just to be sure...you're using SA/blank password from the other machines as well?

Andy

I just back up msdb and call it done. Not as granular as scripting jobs of course. If you're using appropriate change control I think just a backup is good...

I dont think there is as much difference in overhead as you might think. Regardless of where you store it, it takes x reads to get a file from disk...

Parameters.refresh is expensive - means an extra round trip. If you're just trying to generate the parameters collection manually MS published a VB add in that does a great job....

Good point. We'll see if we can come up with something!

Andy

Tried sp_MSdrop_mergesystables?

Andy

Definitely create and test in DTS, then save as VB. Essentially you're using it as a code generator (which is a great idea, similar to recording macro's in Word/Excel that...