Thanks GSquared, but CDC not available on Azure, so that's off the table for me. I'm going to have to ponder Crazy 8's discussions, and derive a solution from there....

That is EXACTLY what I'm looking for. Unfortunately, right off the bat it says only available on Enterprise, Developer, and Eval. I should have mentioned that this is for SQL...

Looks good. I can make that work. Thanks Wayne!

Just thought I'd let everyone know that the Sql Azure Migration Wizard is awesome. I've used it many times now. There is a setting that specifies if data should be...

Hi Vishal. I see you haven't had much luck with this post. The Azure forum here seems pretty dead. Very surprising to me. I would think it would be very...

I don't have to try it Jeff, that is exactly what I was looking for. I remember it now that I see it. Thank You!! Now I just have to...

You are absolutely right. I did not ask this question correctly. I need to go back to the drawing board about how to ask this, and the tables / data...

Thanks. I'll let folks know how it turns out.

Thanks! Not the answer I was hoping for. I could swear I remember a way to temporarily turn that off globally for all tables. Maybe I'm thinking of BCP, but...

Right. I should have mentioned that I tried that, and it pulls down the schema just fine, but I can't get it to pull down any data. I set the...

Wow, this is incredibly old. I forgot the specific details of the solution. I just remember that it was related to encrypted stored procedure(s). Sombody, or something was trying to...

Got it. Thanks! Fortunately (knock really hard on wood) I've never been bit by that one. I've had to rely on my backup many times, but in all those cases...

Hmm, my backup of msdb. Glad I asked because I wasn't baking that up! So I added a new backup plan for master, model, and msdb.

I guess I should probably...

The audit table is overkill in this case. If I did need that much detail, doesn't sql2k8 have some built in autiting?

(Somebody needs a nap. 🙂 )

Oh, right! I get it. I understand the multiple rows thing. I learned that lesson many years ago. I thought the point was that local vars are BAD in a...