You might need to rewrite the trigger. That error cannot magically go away, you need to write sub-queries that do not return more than one value.

If you need help,...

perhaps not an apology, a thank you.

I would agree that Open Source tools can respond quicker, and changes can be made. However it's a double edged sword, as Jeff pointed out. Often there are people that...

Please use full sentences and periods so we can understand each other. It's hard when you run all your typing together.

Can you connect to the Vista SQL Server from the...

Not a bad apology. There's hope.

You cannot restore master to another version. even another patch level can be asking for problems. Master contains version and instance specific information. You must restore to another 2000 instance.

As...

Well, on the bright side they have more disk space.

Quite a few of the developers at Microsoft, but I'm not sure if it's a majority. The people building the language seem to be smart, and they are looking for...

What do you mean by sync?

The Vista machine might have firewall issues preventing this. The firewall is more strict. Also, depending on which version, some versions do not accept remote...

The updating doesn't make sense. You'd have to ask whoever said that what they mean.

A migration is usually to another instance. It could involve and update to a new version,...

My college rugby coach made us play soccer.

Didn't bother with red card or running laps. Wouldn't have been any players left.

Never heard of that, but I suspect that there isn't anything you can do. A detach in that phase would seem to suggest you had the backup files and could...

Be sure you put it back in full mode and then do as Jeffrey suggested.

Until you perform a log backup (in full mode), the log keeps growing.

I think you mean delete un-needed log file backups. If you delete log files made since the last full backup, you lose the backup chain. What if your backup fails?...

It makes zero sense to back up the data folder and backup folder. It's the same data, and arguably the data folder is useless since a backup not made through...