Two ways.

1. script out everything in db A, including permissions and run it in B.

2. Restore B from a backup of A, whack the data you need removed.

ApexSQL has a log tool that will read the 2005 transaction log. You can purchase this, but I'm not sure it shows who performed the transaction. The transaction log isn't...

IP?

It's enabled for database mail, so I don't think there's anything wrong with turning it on.

That certainly will help with SQL skills, but it doesn't necessarily help you with larger projects.

I'd try a few different things and see what works best for you.

That's a good one.

Or if you want to make things easier, at least for me, use DAY(), MONTH(), YEAR() and concatenate those (after casting to char)

http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/analyzingdatastoragetenshowcontigqueries/1438/

or examine this script to learn a few things

http://www.sqlservercentral.com/scripts/Index+Management/30041/

If you have more questions, you need to ask specific questions, not just say you don't understand everything.

Hopefully you're not using notepad/wordpad to open backup files. They're not in human readable format.

Why not just script out the database before each deployment? Then you can use that for...

Thanks and hopefully all the SSC isn't too big a vice. I'd like to think it has some positive benefits in there as well.

I'll concur on the DVR. I rarely...

The 2GB limitation is for Standard edition, regardless of the OS.

The limitations for Enterprise edition vary depending on the host OS.

I think it's personal preference. I'm a leading comma guy.

I don't think you can fake out the tape interface.

Will the virtual tape back up files? Any reason why you can't just have it grab the backup files from...

Actually everything below the "use" is what you would put into the DTS task.

Put the definitions for the variables inline in the code in place of the variables.

Boy that code is a bit of a mess. Is there any chance you could distill down what you are trying to do with the tables?

It would seem that you...