SP2 isn't necessarily an all-or-nothing process. It has patches for all the possible components, which means some could get installed while others might not have gotten installed at all.

Further point,...

Interview question?

Well the answer depends on what job you're interviewing for. Employers will consider their needs first when looking at the answers provided by the interviewees.

Personally, I think it is easier to start off as a Production DBA and move into the development. At least, that's how it was with me and I started off...

DOH! Good catch, Jerry. I was so busy trying to make sure I didn't post code w/o permission that I must have accidently dropped that declare statement.

My bad. :blush:

Seggarman,

Even following your suggestion, Gail's point is still valid. Just because the data is stored in a table in a certain physical or logical order does not mean that's how...

Did you install the client tools for SQL Server 2008? Perhaps this is what the message is referencing.

Glad we could help. @=)

Okay, this code is officially going to be my new best friend. @=)

Thanks, Ggraber! Cookies for you!

Aha. Didn't realize it was a paren. Thanks, Jeff. @=)

You're welcome. @=)

Glad we could help you figure it out.

NP. Glad I could help. @=)

There is no such word as "impossible". @=)

Okay, forget about the INSERT part of the statement for the moment. Run just the SELECT statement by itself. What do you get?

Also,...

It's not always a Kerberos issue, SQLBOT. I've actually encountered this issue on other occasions.

But SQLBOT brings up a good point. Have you actually verified that your SQL Services are...

Possibly, but his code is interupted by the forum turning part of it into a smiley face, which means I get a syntax error...

I don't think you need a cursor & while statement either, but as others have said, we need the table structure before we can accurately help you. Don't assume the...