If all the rows cast to datetime without an error, then you can ignore that warning and change the data type.

Take a backup of the data first, of course, just...

True. I always forget...

Rather don't shrink the database. If you truncate the table then the empty space in the DB can be reused by future inserts.

If you shrink the DB, it just...

Look up convert. There should be an appropriate style that you can use to convert the date into a datetime. Once it's in a datetime, you can convert it back...

Only 431 has sims. All the others are case studies and multiple choice.

Check the cluster logs and the event logs to see if you can find a reason for the service to fail over.

Agent XPs are always switched to 0 as a...

Order by in an insert have no meaning, and if you don't specify the order in a select, no order is guaranteed.

Rather do it this way.

insert into #table

select * from...

It they're written badly, they can be.

Personally, I've not found views to be a problem, unless there are layers upon layers of views. If views reference other views which reference...

What's the data type of the column?

If it's datetime, it doesn't have a format. The format of a datetime is solely due to the way it's queried.

I'm guessing Jeff has something like this in mind. It's not a pivot, it's a concatenation and all the values will appear in one column.

DECLARE @ConcatB VARCHAR(8000)

SET @ConcatB = ''

SELECT...

Why.... ????

If you restored a 2000 database onto 2005, you need to update all the statistics. SQL 2005 keeps more detailed stats than SQL 2000 did. The 2005 optimiser can use...

What method are you usind to see what's been excuted?

Create the login with a matching SID and you should be good to go.

You mean how to match up the newly created login with the database user?

Fairly easy. The link between a login and the database user is the SID. You can...