• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

Unexpected error with SQL Server ENT

Afternoon,

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.

Much thanks.

 SQL Manager Error
0
ampike
Asked:
ampike
2 Solutions
 
arnoldCommented:
Does the other admin use the same system and is able to get the report?
Are you able to use the other admins system and are you having the same issue?
Are you able to view any other data i.e. open other tables?
It might be that your SQL enterprise manager may need to be reinstalled or a .NET update affects its performance.
0
 
shalabhsharmaCommented:
Check the MSSQL logs for exact error.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now