You typically use an insert..select to insert and in that case, you can specify the columns. If you look in Books Online, you will see examples for the insert statement.

As...

Dropping and recreating should give it a new ID, as well as change the versioning. IF there is substantial data in the object, that can take time.

Renaming just changes...

Note that SQL Server will not automatically move data to this file unless it is in the same filegroup.. The default filegroup will still likely be your mdf.

SQL will not...

SQL Server's endpoints are using TDS, HTTP, or SOAP.

If you want to receive some other format, you'll have to write a receiver that takes the data and inserts it into...

Are you moving on the same server or to a new server?

In either case, Gail's #2 will have the least downtime. You can keep taking logs and moving them, getting...

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,...