harsharamoju

Now I have changed it to  schemaname.table in the statement. It is working fine.

What does that mean？

harsharamoju

elect * from table to select * from cp.table

Why do you want to add "cp"？And what's cp？

Show us your screenshot of your SQL table's schema in the SQL Management Studio。