Rechana Rajan - Tuesday, January 24, 2017 4:28 AM
I don't know what's going on, then. The only thing I can think is that there's something you haven't told us. You might try dropping the view and recreating it using the statements you've posted in this thread. Better still, script out the tables, the view and the user and recreate them in a new database. Do you still get the error? If you don't, work back and see what's different between the two databases. If you do, please post the scripts and I'll see whether I can reproduce your problem.
John