An Unexpected Error Happened During This Operation Sql Server
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 reall
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2000 Forums SQL Server Administration (2000) An unexpected error happened during this operation Reply to http://forums.databasejournal.com/showthread.php?18495-SQL-msg-%22an-unexpected-error-happened-during-this-operation%22 Topic Printer Friendly Author Topic peter_dtm Starting Member United Kingdom 7 Posts Posted-08/03/2010: 09:30:30 SQL 2000 SP4 Standard EditionDell 2850 W2K SP4 4GBRecently the PDC was upgraded to a w2k3 DC. Following that move the following problems occur :1) Try to open a table in Server Enterprise Manager gives this error : An unexpected error happened during http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=148196 this operation, [MS Visual Database Tools] - Not enough storage is available top complete this operation 2) A previoullsy running SP now throws an error complaining that a cursor read from a table pvalue varchar(255) to @pvalue varchar(255) gives an error this is the actual error : Server: Msg 245, Level 16, State 1, Procedure afReportSprayDryer, Line 138Syntax error converting the varchar value '1.01' to a column of data type int.code extract of line around 138FOR READ ONLYOPEN curFillEmptyset @Error = 0>>>>line 138>>>>>>>> FETCH NEXT FROM curFillEmpty INTO @lclTime, @Descript, @PValueIF @@FETCH_STATUS <> 0BEGIN SET @TransferStart = @RBK_PhaseStart set @ErrorMsg = 'Could not find report SPT_REPORT1' + '...' set @Error = 1ENDELSE SET @TransferStart = @lcltime -- define start for search for fines returnIF @RBK_Unit = 'H1E01' SET @Dstunit = 'L1D01'IF @RBK_Unit = 'H2E01' SET @Dstunit = 'L2D01'-- Find the powder tranport batches, that have cooperated with this batchWHILE @@FETCH_STATUS = 03) If I try and open the SQL erro logs from SQL Server Ent Mnager I just get an egg timer - nor can I find .
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. http://www.bigresource.com/MS_SQL-Cannot-open-table-in-SQL-Server-Enterprise-Manager-fNhR37CI.html View 3 Replies Similar Messages: Cannot 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 an unexpected Server Service Manager Off How Do I Enter NULL In A Table 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 an unexpected error Query How To Switch Off Automatic Blanking Of Table Views In Enterprise Manager ? SQL Server Enterprise Manager 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.Than