Home > An Unexpected > An Unexpected Error Happened During This Operation Sql Server 2000

An Unexpected Error Happened During This Operation Sql Server 2000

try it and let me know if it works for you or not. There is no problem cleaning up the connection/resultset either.Any ideas where to look? Exists another work around. And what is the origin for this error?Thanks in advance,Asnate View 2 Replies View Related Cannot Open Table In SQL Server Enterprise Manager Nov 6, 2000 When do right click on http://svbuckeye.com/an-unexpected/an-unexpected-error-happened-during-this-operation-sql-2000.php

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 ANy ideas? The SP 3 box has the error and the SP 2 box does not. However, the data will only insert 1 time.

You cannot post JavaScript. You cannot delete your own posts. I have installed SQL Server 2005 Express and SQL ServerManagement Studio Express.

Forgot your password? To start viewing messages, select the forum that you want to visit from the selection below. Today, I still cannot open Enterprise Manager. I can ping the servers with SQL on them, but I get timeouts and 'Connection Broken' in EM.

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. Visit our UserVoice Page to submit and vote on ideas! Reinstall it again Reply With Quote Quick Navigation MS SQL Server 7/MS SQL Server 2000 Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Database Discussions http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=148196 Anyone know where it is?

Good Hunting!AJ [email protected] Post #192115 marianna arossamarianna arossa Posted Monday, June 20, 2005 9:46 AM Forum Newbie Group: General Forum Members Last Login: Thursday, January 24, 2008 7:59 AM Points: 5, i restarted the system it worked just one time properly and then when i again tried it did not work for me. I recently had to reinstall SQL server due to problems with IP sockets. 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

The form pops up and no rows appear. http://www.sql-server-performance.com/forum/threads/an-unexpected-error-happened-during-this-operation.6925/ The SQL agent is running. I'm not sure it's because of my soft, but my clients are quite annoyed.I have had this situation on my own server , and the only thing I could do was Come on over!

I can run SQL Analyzer and run "select * from table_name". have a peek at these guys View 3 Replies View Related Grid Pane In The Table In Enterprise Manager Jan 13, 2004 HIWhen you right click open table to return all rows, click on the "Show/Hide Grid 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 If any of you can help, I'd really appreciate it.

Terms of Use. I tried re-installing SP4, but this did not fix it. Good Hunting!AJ [email protected] Post #192305 kevin tallkevin tall Posted Tuesday, July 12, 2005 2:06 PM Forum Newbie Group: General Forum Members Last Login: Friday, December 9, 2005 7:31 AM Points: 1, http://svbuckeye.com/an-unexpected/an-unexpected-error-happened-during-this-operation-sql-server.php View 6 Replies View Related Cannot Open Query Analyzer From Enterprise Manager Nov 29, 2006 After I installed MSDE, I cannot open QA from Enterprise Manager - error message says: the

Friday, June 30, 2006 6:20 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 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 Colleagues with other installations do not get the error, and their systems return the rows correctly.

Privacy statement Help us improve MSDN.

Please help. Username: Password: Save Password Forgot your Password? We've done alot recently to try and fix it:Reinstalled MDAC, reinstalled SQL Server SP, increased memory, shrunk the trans log, reindexed the table, changed the cursor around (made it readonly as Enterprise Manager Turns SQL Server Service Manager Off Dec 6, 2006 IF someone can assist me.

I will update this link if I get an answer. The only numeric fields are two INTs that are also ID's (PK and FK). These fields can not be edited eitther from MSAccess nor Enterprise Manager.What can be done on the table, resp. this content Another option i tried is to create a linked server on my local server: that does work, only now i can't add/edit/delete..I really want to work with enterprise manager, but is

Last week, using Enterprise Manager, we were able to open any of these tables and return all rows. DTSRun OnStart:DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart:DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart:DTSStep_DTSDataPumpTask_2 DTSRun OnError:DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Errorstring: [Microsoft][ODBC Visual FoxPro Driver]Cannot open filee:private.dbc. That works on the Northwind and customer database tables - every time. You cannot delete other posts.

Where do I find theEnterprise Manager?Robert View 2 Replies View Related SQL Server Enterprise Manager Mar 20, 2006 I am trying desparately to build a user defined function on the Microsoft It seems to have disappeared from the server. You cannot edit your own topics. View 2 Replies View Related Decimal Places Error On Opening SQLServer Table From Access Project Oct 31, 2006 One single table when openen from a MSAccess project file gives error:The setting

CHECKALLOC or file manipulationoperation is completed.Backup or restore operation terminating abnormally"How to solve this problem? please help me! You cannot edit your own events. Your name or email address: Do you already have an account?

Any update to this would be appreciated. I have tried deleting the value, entering spaces, entering the string NULL or the string ; maybe some other tries as well, but none works, i always get that error message I can access the MSDE Databae from another machine fine, but when I try to register that DB locally in Enterprise manager I get this error. No errormessages appeared and I don't think I saw anything unusual inthe log file.However, I can use Enterprise Manager on a differentmachine and connect to the database (so the databaseitself seems

The SQL agent is running.