use database
go
select * from [schema].[tablename]
i use the above, the weirld part is that it works for all other tables except this one, even i try open it in ssms or try to use ssis to export it, gave me the same error, so, what else you will try from here ?
ddfg