All,

I couldn't query the table regardless of the actual SQL. I tried limiting the return data but that didn't work.

Also tried using DTS to import the table to the same DB in hopes of playing around with the copied table w/o causing any harm to the original. Same results - it hangs.

After I did an sp_who, I noted a user was still connected to the database and this user was set up to perform an import in to this table. That seemed a little coincidental and I later found out the credentials were shared so others were using it. I killed the 2 connections and the problem went away.

Thanks to everyone for the suggestions.

Mark