An Unexpected Error Happened During This Operation Sql Server 2000
New? Advanced Search Forum Database Discussions MS SQL Server 7/MS SQL Server 2000 SQL msg: "an unexpected error happened during this operation" If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: SQL msg: "an unexpected error happened during this operation" Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 11-01-2000,11:01 AM #1 David Singleton Guest SQL msg: "an unexpected error happened during this operation" I have W2K Adv, SQL 7 Enterprise in a workgroup with mixed security. The SQL installation is an almost entirely default install. At the console, in SQL Enterprise Manager, when I select open a database, open tables, select a table, open table, and select all rows the system displays "an unexpected error happened during this operation". As far as I know this has never worked on this installation. The error occurs with every logon account (including sa and local administrator accounts), both the "all rows or top row" options, every table, every database (including the customers database and the Northwind database). I have tried adding administrators and accounts as users of the databases etc. and given the accounts all the permissions I can dream up. There are no interesting messages in the event viewer. The SQL agent is running. Technet found two documents but not related to the problem. I can run SQL Analyzer and run "select * from table_name". That works on the Northwind and customer database tables - every time. Colleagues with other installations do not get the error, and their systems return the rows correctly. If any of you can help, I'd really appreciate it. Reply With Quote 11-01-2000,02:32 PM #2 MAK Guest SQL msg: "an unexpected error happened during this operation" (reply) I believe its an MDAC version problem. If it is a test Client, Try installing English query on it, it replcaes your old MDAC. -MAK ------------ David Singleton at 11/1/00 12:01:24 PM I have W2K Adv, SQL 7 Enterprise in a w
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Retired content Samples We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: New Database Diagram - An unexpected http://forums.databasejournal.com/showthread.php?18495-SQL-msg-%22an-unexpected-error-happened-during-this-operation%22 error happened during this operation. SQL Server > SQL Server Tools Question 0 Sign in to vote I try to add a new database diagram to sql server 2000 using Enterprise Manager and I get this error: SQL Server EnterpriseManagerAn unexpected error happened during this operation. How do I debug this? Friday, June 30, 2006 6:20 https://social.msdn.microsoft.com/Forums/en-US/c1cdb581-7277-413d-8c98-b5a9473066c4/new-database-diagram-an-unexpected-error-happened-during-this-operation?forum=sqltools PM Reply | Quote All replies 0 Sign in to vote I had this Problem when i wanted to create a table in any (i.e sys and user) database. i restarted the system it worked just one time properly and then when i again tried it did not work for me. i dont know what the problem is. [uote user="RobertRFreeman"] I try to add a new database diagram to sql server 2000 using Enterprise Manager and I get this error: SQL Server EnterpriseManagerAn unexpected error happened during this operation. How do I debug this? Sunday, July 09, 2006 1:49 PM Reply | Quote 0 Sign in to vote Hello Robert, My bug in SQL server 2000 got solved what i did was I installed SP4 in SQL server2000. try it and let me know if it works for you or not. you can get SP4 from the microsoft webdite for free Narayanan Sunday, July 09, 2006 11:06 PM Reply | Quote 0 Sign
rows command, I get the following error "An unpected error happened during this operation" Reinstalling the client Tools has not helped. Any help would be appreciated. View 3 Replies Similar Messages: Cannot http://www.bigresource.com/MS_SQL-Cannot-open-table-in-SQL-Server-Enterprise-Manager-fNhR37CI.html Open Table In SQL Server Enterprise Manager Enterprise Manager - Unable To Open A Table Enterprise Manager - Cant Open Tables Enterprise Manager Takes 10+ Min To Open Cannot Open Query Analyzer From Enterprise Manager How To Open Enterprise Manager Using Command Promp Help: Table Name Displaying Twice In SQL Statement Inside SQL Server Enterprise Manager Help! Enterprise Manager Turns SQL Server Service Manager Off How Do I Enter NULL In A Table an unexpected Cell In The Enterprise Manager UI For Table Data Entry? Export SQL Table Using SQL Enterprise Manager Sql Enterprise Manager - Copy Table Rows In Table Not Showing Up In Enterprise Manager Grid Pane In The Table In Enterprise Manager Unspecified Error Opening Table(s) In Enterprise Manager Enterprise Manager Cannot Display Table Records Or Run Query How To Switch Off Automatic Blanking Of Table Views In Enterprise Manager ? SQL Server Enterprise Manager an unexpected error SQL Server Enterprise Manager.MSC SQL Server Enterprise Manager.MSC SQL Server 7.0 Enterprise Manager Sql Server Enterprise Manager Sql Server Enterprise Manager Server Enterprise Manager Where Is SQL Server Enterprise Manager? SQL Server Enterprise Manager Enterprise Manager For SQL Server 2005? Can I Download The Enterprise Manager For SQL Server? Server Explorer (VS.NET) Vs. Enterprise Manager SQL Server Enterprise Manager Access How Does Enterprise Manager Connect To SQL Server? Not Seeing Any Sql Server Logs In Enterprise Manager Need Location Of MS SQL Server Enterprise Manager ADVERTISEMENT Cannot Open Table In SQL Server Enterprise Manager Nov 6, 2000 When do right click on the table in SQL EM and select Open Table | Return all rows, get Error:An unexpected error happened during this operation. [Query]- Query Designer encountered a query error: unspecified error.It's happening on all tables, all databases, all protocols, all servers, on 2(!) of 3 installations of SQL EM. I can successfully run Select in Query Analyser against the same servers/dababases.Today is the first day it started. I cannot recall anything particular I've done on Friday that can cause this.Thanks View 1 Replies View Related Enterprise Manager - Unable To Open A Table Jul 26, 2001 After having installed my software at customer's I found out that it's impossible to open tables from Enteprise Manager (Qu