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

An Unexpected Error Happened During This Operation Sql Server 2000

Now I go and add/install theServer component and then Service Pack 3a.It seems that Service Manager won't start up (I get an hourglass cursor)and now I find that Enterprise Manager won't You cannot send private messages. Unfortunately, it doesn't always seem to solve the problem. any ideas ???????Cheers View 9 Replies View Related Rows In Table Not Showing Up In Enterprise Manager Nov 20, 2000 I have just installed SQL Server 7 on a server. http://lanprolab.net/an-unexpected/an-unexpected-error-happened-during-this-operation-sql-2000.php

Any ideas anybody?Thank you.Alexander View 6 Replies View Related How To Open Enterprise Manager Using Command Promp Sep 21, 2006 how to open enterprise manager using keyboard shortcut?and how to open I am getting the below errorAn unexpected error happened during this operation.[Query]- Query Designer encountered a Query error: Unspecified errorWhen i use Query Analyser i am able to retrive the DataPls Sep 9, 2005 I have a column defined as smalldatetime. Anyone know where it is? http://forums.databasejournal.com/showthread.php?18495-SQL-msg-%22an-unexpected-error-happened-during-this-operation%22

I have rebuilt the server twice using Windows 2K SP4 and SCL 2000 SP3, but as soon asI use Enterprise Manager to view a table the "Not enought Storage..." message appears. I stopped the services and then rebooted again,but no luck either. 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. ANy ideas?

The tables are actually there but Icannot access them through Enterprise Manager.I assume that a re-install will probably fix it, but I'm hopingto avoid it.Help--Posted via http://dbforums.com View 1 Replies View So if it's a driver corruption, it's happening during the SQL install, or SP update or a bad driver from Dell.Please post if anyone can do this. all columns.This is the case when I try to create a view in enterprise manager also. 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

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 Sejal ------------ MAK at 11/1/00 3:32:47 PM I believe its an MDAC version problem. The only numeric fields are two INTs that are also ID's (PK and FK). http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=148196 I want to know if Enterprise Manager exists in Sql Server 2005.

You cannot edit other posts. What to try? You cannot rate topics. After some hard googling for 2-3 days i did found the solution and the cause of this problem is related to some shared ddl file (i'm not sure whether it is

Otherwise it sits there as Process id 51 Master - runnable (this is the SEM) and Process id 52 - DTS sleeping.Nigel Phact View 7 Replies View Related Where Is SQL I don't know if this is causal or coincidental yet. You cannot edit other events. I had to install sqlserver 2000 using k=dbg and skip the MDAC install as it was giving me an install error but this shouldnt have mattered as I am running XP

Today, I still cannot open Enterprise Manager. news It consumes alot of mem.That is why there is QA Post #200250 Brian-247838Brian-247838 Posted Friday, July 22, 2005 5:25 PM Forum Newbie Group: General Forum Members Last Login: Friday, July 22, I can send out a test E-mail from Enterprise Manager to operators, but I cannot run this Transact query: EXEC master.dbo.xp_sendmail @RECIPIENTS = araz***@***.com(removed email address), @SUBJECT = 'test' I receive:Server: Help would be appreciated.

Process Exit Code4. I also check another database andthoses display the table names in the SQL statements correctly. thanks,Jonathan View 2 Replies View Related Sql Server Enterprise Manager May 14, 2008 I have a AS400 that I retrieved data from and imported into SQL 2000 Server. http://lanprolab.net/an-unexpected/an-unexpected-error-happened-during-this-operation-sql-server.php I can successfully run Select in Query Analyser against the same servers/dababases.Today is the first day it started.

You cannot delete your own topics. You cannot edit other topics. Now when I use the SQL Enterprise Manager (SEM) Return All Rows option to open a table, or you attempt to create or design a view, I get the following error:

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,

When Iright click a table and select Open Table->Return All Rows it gives me anerror dialog "An unexpected error happened during this operation". If it doesn't, where can I download it from? No, create an account now. I cannot recall anything particular I've done on Friday that can cause this.Thanks View 1 Replies View Related Rows In Table Not Showing Up In Enterprise Manager Nov 20, 2000 I

The memory could not be "read".Any ideas what this is?Paul View 1 Replies View Related Trigger / ODBC Error On SQL 7 Enterprise Manager Oct 5, 2001 Hhmm! Solution: (This is related to the client computer only. Does anyone know why the table namewould display twice in a table inside of a particular database? http://lanprolab.net/an-unexpected/an-unexpected-error-happened-404-unknown-error.php The time now is 02:06 AM.

All Forums SQL Server 2000 Forums SQL Server Administration (2000) An unexpected error happened during this operation Reply to Topic Printer Friendly Author Topic peter_dtm Starting Member United Kingdom 7 Username: Password: Save Password Forgot your Password? When I right click a table and select Open Table->Return All Rows it gives me an error dialog "An unexpected error happened during this operation". The SQL installation is an almost entirely default install.

Any other ideas? During backup running, i had cancelledabnormally, when next time i take backup it shows the following error "Microsoft SQL-DMO(ODBC SQLState:42000)" "Backup,CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such asCREATE FILE) 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 View 1 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

and given the accounts all the permissions I can dream up. How can I get updated/changed data every 15 minutes?HELP!!!!!Lisa Jefferson View 10 Replies View Related Server Enterprise Manager May 24, 2006 Why does the SQL Server Enterprise Manager seem to block Any Ideas? 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 this operation, [MS Visual Database

Can I Download The Enterprise Manager For SQL Server? Privacy Policy. I'm using NT4.0 and SQL Server 7.Thanks,Robert View 2 Replies View Related SQL Server Enterprise Manager.MSC Jun 25, 2001 I've managed somehow to corrupt the Enterprise Manager.MSC file(it has ocurred several