My son got Civilization on the XBOX and enjoys it.

Me, I'm more a Bejeweled guy. Something short and quick.

I'd agree with both points above. USe batches, and if you can test, try dropping indexes.

Are you removing the tables on server b? If not, then the script needs to handle that.

SQL compare will do this (from my employer): http://www.red-gate.com/products/SQL_Compare/index.htm

You could also use Powershell to...

Articles as always welcome....:hehe:

You guys know you can join Facebook and not post anything about yourself. Even use a fake name and just view stuff?

I don't think you'll have much luck reigning in Brandie. She lives in FL, and if she doesn't have a gun, she can borrow one from Andy Warren.

I'd leave her...

Check it later. It's fake, but pretty funny. Only on FB from what I can see.

Holy Smoke - Be prepared to laugh out loud http://is.gd/f4cHh (Facebook)

Somebody should post dbcc timewarp on Connect 😉

First, don't grant rights to a user. If there's one, he/she will be replaced, or you'll add someone else. Take 10sec and write

Create role MyDenyRole

Then I'd do a GRANT on...

I wrote about this for a 2008 exam book and found very few references at the time. Here's a few I did find

http://www.mssqltips.com/tip.asp?tip=1320

http://msdn.microsoft.com/en-us/library/ee819082%28SQL.100%29.aspx

http://www.simple-talk.com/sql/database-administration/sql-server-consolidation/

Run

Starting a new year today (http://stevejonesssc.blogspot.com/2010/09/goal-update-misc-accomplishments.html)

You can set permissions by schema, or you could assign permissions by object (using a role).

Ultimately, if you have people with DDL_Admin and they are dropping table they shouldn't be,...

Or make sure that this page is using Windows Auth and only you, or other DBAs, can execute stuff.

What you can do as well is just create a stored proc...

You could offer to call MS and get support, but my guess is that they would tell you what Gail has listed here.