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

What is notifying you of this? Is this an error message when you try to detach the database?

If so, please list the full text of the error message.

This may or may not work for you. NOTE carefully the ON part of each JOIN statement

Select Table1.ID, Table1.FirstName, Table1.LastName, Table2.Answer, Table4.Title, Table5.PageHTML, Table6.Location

From Table1

Left Join Table2

On Table1.ID=Table2.AgentID

and Table2.Answer...

Sounds like either an ownership chain issue or your Linked Server is set up wrong between the two.

EDIT: Sorry. To clarify, check your Linked Server to make sure it has...