Either a backup or possibly a log reader like Golden Gate's LogPI or Lumigent's Log Explorer could script what you need.

I agree with lholman, EM is the way to make this change.

Matt's a friend. He understands and I'm sure he's laughing about Steve the SQL Nazi.

What about recommendations for those strange artsy, Cannes-art-festival people? They like the movies the experts pick! (apologies Bob if you're one of those artsy folk).

I'm not sure this isn't mining....

I know, I had this one ready to go last week and it didn't get run for some reason.

Steve, Andy, and Brian are attending.

Sign up with the "SSC" source code and come to our Tuesday night party!

Rebuild the clustered index on the new filegroup.

You can use a third party tool, like SQLCompare from RedGate or you can script out the sprocs and execute the script on the dest machine. If they are owned...

There are two code spaces. A promotional code, usually used for discounts, and a source code, used for referrals. If in doubt, email PASS (passhq@sqlpass.org) and let them know you...

Clark,

I'm sorry that you didn't get in. PASS has the final vote on who gets in, not us. The requirements were the same as last year and the year before....

, Apparently the ALT-TAB got in the way of that article. I've corrected that part.

The mining of data I referred to was analog, in...

It's flaky in reporting situations because as soon as you depend on it, you've lost the ability to ensure it's there. A backup restore should be allowed because if there's...

I think I'll be afraid of the "probe"

Easy on the religion. AFAIK, all religions are peaceful, it's some of the leaders that mess things up.

Boy, this is a can of worms and it's an emotional topic, so I'm not trying to offend anyone.

First it's not legal to discriminate in the US. Race, gender, or...