Nice question, but could have been worked out a little better.

Can you post the actual query plan?

Installing SSMS doesn't stop the database.

If your server is so important, you shouldn't install client tools on it, but on a seperate client computer.

The Excel SQL syntax (or whatever it is called) is more like this:

DELETE * FROM [mySheet$]

What's the question?

I got it right, but only because I thought you had to link the mirror to the principal first, and then the principal to the mirror (which starts the mirroring...

Nice question, thanks.

Your questions is too vague to give a decent answer on.

You can create different stored procedures for different functionality. I wouldn't want to create one single sp for everything, just...

Easy question, but explanation is a bit lacking.

Is that a typical scenario?...

Did you try to repair it?

Open up the 2005 project with BIDS 2008. An upgrade wizard will start which will guide you through the process.

Give special attention to lookups and script tasks/components.

In the list of software programs in the control panel, do you see "Microsoft SQL Server 2008 Native Client"?

If no, you need to install it using the SQL Server set-up.

If...

You can just download the .iso (it's only 4 GB :-D) and run VirtualClone Drive to mount the iso.

You can create a new table in the OLE DB Destination component.

Or you can use the Transfer SQL Objects task.