Jeff Moden (8/29/2013)

It's beyond me, too. But then again, I wouldn't even try to...

Thanks to everyone who answered me.

I didn't mean to imply that I have doubts about avoiding cursors and loops. I do avoid them whenever possible because I respect the...

I respect the general wisdom about not using cursors and loops and have usually found a way to avoid them.

But I have one data upload from a vendor in a...

Is it any wonder that people don't take pride or ownership anymore? I'd argue that the problem starts higher that either developers or QA. It oozes from the...

I also have a real problem with being so 'philanthropic' with my personal data. If it's aggregated into a truly anonymous grouping, that's different. But when it's the...

Thanks for the response. Yes it was a permissions issue so I ended up using backup and restore d/b which worked fine. Calling that Copy Database a 'wizard'...

Make that three of us. Every time I run the Copy wizard, it either throws a permission error like yours or just hangs completely.

I agree with both of you. I've used BCP and SSIS repeatedly. Each technique has its good uses and I probably should have mentioned that most of...

Why would you say it is not a best practice? It is, admittedly, a brute force approach, but it does give good control. What makes it a...

@jeff:

Sure, what do you need to see? I told you I'm very new to the whole topic of users/privs/roles/security in general.

Also, how do I send a pm?

I stand corrected. I checked BOL briefly but I am not an expert with bcp by any means and haven't had any need to use a format file; I...

@jeff:

Thanks for the information, it answered a lot of my questions. I'm an accidental DBA at best. I never grant individual users any special privs so...

Thank you. It isn't elegant, but it works. I prefer elegant, but I'll settle for brute force if I have to. :laugh:

Of course, bcp is the better choice just to spit out a lot of rows into a text file, but I don't think it can do a fixed-length file.

However,...

Forgot my other question regarding the 'horrible mistake' of granting a proxy. I don't know that I did that and wouldn't want to, but I just don't know. ...