I prefer detach/attach, but I agree with Tim, either will work.

I've usually just randomized names, take 100 last names, randomly replace existing data in there.

Phone numbers can be sequenced, all 555-0000, 555-0001, etc.

Other stuff, just need to move it around....

I like seeing the proposals for new nuclear plants. The newer designs (I hope ) will get better and pay dividends.

Matt, not sure I agree with your analysis. Part of...

First, you know you shouldn't use shrinkdatabase except in rare instances. So I'd say this should be done rarely and then just use the select all, save feature of...

Biofuels as diesel probably isn't a long term solution. Though I'm not sure what the impacts have been in Brazil, which has a large scale program there.

I'm not sure I...

If the app supports separate tables, create them, move them to the new database, drop the original tables.

Now create a view of the tables in the other database (cross database...

Couple things.

why does this need to be a subquery

Does the subquery join (inner) on the columns returned?

I agree with Matt. Log backups are likely not being run and thus the log grows constantly.

You need to be sure you run full and log backups.

Looks good. Be sure you contact the people before patching/remediating and ensure you don't break anything. And give them deadlines to correct actions.

For #1, if you can or have something...

Also, are you using Windows or SQL Auth? If it's Windows, you need to be sure that you can failover as the security needs to be setup across domains. Otherwise...

A login doesn't have rights to a database, it has rights to the server. You must create users to access a database and map them as Sugesh has noted.

Read up...

A couple things.

First, can you switch it out of Read only mode?

Second, be sure that the files themselves (MDF/LDF) in the filesystem aren't read only.

I agree with Adam. you should not be able to add those columns in if they are not GROUPed.

I agree with Andras, but be careful of revoking permissions to c: and all subdirectories. There are things that the service account needs rights to.

More likely I'd handle this administratively....

I'm not sure about biofuels myself. It's an interesting idea, essentially using solar energy over time to create fuels, but I think it does need to be managed.

I've heard that...