I am a domain admin and am connecting remotely to one of our SQL Database servers. I am trying to see inside one of the "Views" of a database. By doing the below:
1. Navigate to View for a paticular Database.
2. Right mouse click View and go to "Open View" and then click on "Return All Rows".
But when i do this i am getting the below error.
"An unexpected error happened during this operation"
Another domain admin from my team tried to view this view and is able to load the view without any problem. This issue appears to be only happening with me.
I have tried deleting my profile from this server (C:\Documents and Settings\my_profile), logging in again to have it recreated. But the problem still remains.
We are using SQL Server Enterprise Manager Version 8.0 on Windows Server 2003 Standard Edition SP2.
Please advise how I can resolve this issue.