• Is it actually a table, or is it an alias for a table elsewhere on the server?

    do you see any error messages when you try to query the table from the other server, or does it return an empty dataset with all the right columns?

    Thomas Rushton
    blog: https://thelonedba.wordpress.com