You can also do this with SSMS

Here's a link: http://msdn.microsoft.com/en-us/library/ms175890%28SQL.90%29.aspx

It's a bug in the engine, and I'm not sure how many people will run across it, but it might be nice to know this.

The explanation has been changed.

The backup is always made from the instance, so it goes to drives that are visible from that instance. Local might have been a poor choice of words, but it...

OK, wanted to be sure.

I think the problem is that you don't have your string enclosed in quotes. If you were to print the dynamic SQL, I bet it...

Maintenance plans include a small subset of SSIS and contain their own installation of an embedded SSIS. Prior to SP2 they required SSIS to be installed. After that, some basic...

What are you passing in for @movies?

If you generate a set of random numbers, you can use Substring to extract out a set, like the first 3, and prepend and append parens.

select '(' + substring( randomstring,...

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.