Why are you explicitly calling that particular column? Also, you really should explicitly define the columns you want returned even if you want all of them returned.

Tried something similiar in a Sandbox database. Under compatibility mode 80, query would work. Under compatibility mode 90, I got the error you did.

Something is different, you just...

What versions of SQL Server? What compatibility mode on the databases?

I see the problem:

select INSPTYPE,* -- right here. You are specifying INSPTYPE explicitly and it is also included in the *, so it is here twice.

from APINSP

where insptype...

What are the table definitions between the two environments? Also, are there any differences between how the two systems are set up? Different collations, something?

Two things. First, what have you written so far to solve this problem. Second, based on the data in your original post, what whould be the expected output.

A...

Looks like you should be able to accomplish this task. Right click on the server in the Object Explorer, go to the Advanced Page. You should be able...

Now this is doable. We do...

. (7/22/2009)

---

If you're going to tell them they're not posting right then it would be a good idea if you could give them the link to the information about the...

No, and No. The x64 version needs the x64 verions of the OS, which requires that it be installed on x64 hardware.

Is it me or do I just not have enough caffine in my system yet?

?? Okay, did you have a problem you wanted help with, or did you just want to know what type of lock the code represented?

I'd like to see the solution also. I'd also like the OP to post the code he has tried writing to solve his problem as well, though, before you...

peter.nguyen (7/22/2009)

---

Sorry.

Attachments for more sample data. ignore the first sample data I sent earlier.

Here is a pic of the output that is required:

Thanks again so much for wanting to help...

Your data still doesn't match your ariginal picture. Is there a query that is run against this data that produces the data as seen in your original post?

Nevermind, STILL...