That's so zen...

Andy

Sure. One of the tricky things to test is someones ability to figure out something that they DON'T know. Can I tell this Steve guy to take a look at...

Right now you'd have to write a lot of code to generate the script I think. Red-Gate has a new product out (which I'll be reviewing in the next week...

David, love your description of the 8th dan DBA. LOTS of truth to that. Thanks for the comments Jon!

Andy

I don't know that dynamic sql is always bad. You could create a new table that would hold the user spid and a key, then insert your 50 values or...

Conventional wisdom says not to, Im not so sure myself. The biggest reason to me would be the additional safety net of having logs on a separate array if something...

Push it into a table and refresh periodically.

Andy

Andy

I hear you. It's nice to know everything, but I think those days are gone! Thanks for the comment.

Andy

I believe its a built in limitation of the provider. It's not a speed demon as it is, you don't want to return a couple hundred thousand rows. I'll try...

I think maybe it's worth rethinking the idea of passing the file name to the package - a better approach would be to read the file name from somewhere -...

That's good enough, if that is what you need. You could use DMO also. There is no mechanism for granting access across databases other than explicitly doing so as you...

It's a good point that tools (and sample code as we discussed earlier in the thread) often fail on case sensitive databases. Not sure how to fix this. For me...

Sure...though we could have been in FLORIDA. Steve, order some warm weather for that week!

Andy

David, yes, more spindles is good. Lots more is better! I should have clarified. I recommend figuring how how many spindles you need (or can afford), but then getting the...

You and Leon must the only ones left!

Andy