You could use a function like this one: http://www.sqlservercentral.com/scripts/Random+Numbers/65032/

You can then CAST numbers to character values. Move the decimal first to get the number of digits you need.

Adding the PK later will be overhead and more difficult. Adding it now is fairly trivial now, and it won't take much for you to code around it. I'd recommend...

That one doesn't surprise me or make me wonder. It's what I expect.

6 months? I've struggled to remember things I did last week at times.

Everyone definitely needs a log

incorrect.

a backup does not affect anything in process. It captures all changes that are committed up to the end of the backup, but does not lose anything.

How are users connecting?

My short answer is that if you can force them to run dynamic SQL through a proc of some sort, you could use REPLACE to strip out...

First, all tables need a PK. Otherwise you'll get into issues at some point trying to work with the individual rows. Set one up for all tables.

Second, how do you...

This is logged somewhere. It's been a low priority feature, especially with relatively few people using the briefcase, but I'll bump it up a bit.

Coffee isn't necessarily for steak. Maybe after, with the "adult beverage group" included.

First, a diff contains all changes since the last full backup. So if you make 1 change, then run a diff, then make a 2nd change and run a diff,...

You need to make sure that you perform regular log backups to ensure that it does not grow so large again. In doing your log backups, you do not need...

Keep in mind that when you connect to B, the backup is made local to B, meaning from the drives that the service account on B can see.

There are lots of people that are consultants or DBAs that list resumes on their blog. You can try Pinal Dave, maybe Brent Ozar, but you don't want to necessarily...

I believe this is true. Integration Services is the subsystem for running packages. They can be stored in msdb or in the file system, and built in Visual Studio or...

Database Mail should work in all editions except Compact and Express.