We just had an old SQL 2000 server moved to our offices.
When we try and run a SP they had written it doesn't return any data.
So, I tracked it down to the views it is referencing.
It looks like all the tables return records...BUT no view I select returns records. Doesn't matter which view it is...it won't return any records.
Again, we just stood up this server. It was working in the other location.
Tables work - views don't