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

An Unexpected Error Happened During This Operation Sql Server

As far as I know this has never worked on this installation. And what is the origin for this error?Thanks in advance,Asnate View 2 Replies View Related Enterprise Manager - Cant Open Tables Jun 19, 2001 If we attempt to open a table And the enterprise manager can't connect to the local database. 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 weblink

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 It does this for all tables in this particular database. 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 It does this for all tables in this particular database. http://forums.databasejournal.com/showthread.php?18495-SQL-msg-%22an-unexpected-error-happened-during-this-operation%22

it is as follows:An unexpected error happened during this operation.[Query]-Query Designer encountered a Query error:Unspecified error.I dont know what to do. Error source: Microsoft OLE DB Provider for ODBCDrivers Help file: Help context: 0 Error DetailRecords: Error: -2147467259 (80004005); Provider Error: 171(AB) Error string: [Microsoft][ODBC Visual FoxPro Driver]Cannotopen file e:private.dbc. We have clustered Dell PowerEdge 2850 servers w/ 4GB Ram, connecting to a CX300 SAN. While the EM is diplaying this dialog the EM screen looks like Internet Explorer and says "Action Canceled - You might not have permission to view this directory or page using

We've tried reinstalling SQL, and even rebuild one of the 2-node clusters from the ground up using different media. This error is occurringon one database on one server. We have a number of pages that query this table. The SQL installation is an almost entirely default install.

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. Query Analyzer works sometimes and sometimes doesn't. 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 http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=148196 Last week, using Enterprise Manager, we were able to open any of these tables and return all rows.

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 When you add a table to create a view, I cannot see all the filed names . Enterprise Manager Cannot Display Table Records or Run Query P: n/a Frank Rizzo via SQLMonster.com I have a new installation of SQL Server 2000 Dev Edition on a Win2K3 Standard Edition The stmt looks as expected and I can even run it manually and it works fine.

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". http://www.sql-server-performance.com/forum/threads/an-unexpected-error-happened-during-this-operation.6925/ Any other ideas? Sejal ------------ MAK at 11/1/00 3:32:47 PM I believe its an MDAC version problem. Do I need to somehow reinstall this Stored Procedure?

That works on the Northwind and customer database tables - every time. have a peek at these guys I also check another database andthoses display the table names in the SQL statements correctly. DTSRun: Executing... ThenI see a series of audit login audit logout pairs in the profiler but nothing else, where I would expect to see more Queries from that page on other tables.If I

What's it doing, connecting toevery database? View 1 Replies View Related Cannot Open Table In SQL Server Enterprise Manager Oct 24, 2005 I recently installed SQL 2000, runing on a Win2000 Server. Authentication is on NT logon ID.Create Trigger [SGIACCTINS] on [ACCOUNT] for insert asinsert into SGI_ACCT_DB (accountid,account) select accountid,'I' from insertedThe error message, this is in SQL Manager, is Microsoft SQL-DMO (ODBC http://svbuckeye.com/an-unexpected/an-unexpected-error-happened-during-this-operation-sql-2000.php I want to get back to .Anybody know?Thank you.Tom View 1 Replies View Related Export SQL Table Using SQL Enterprise Manager Apr 25, 2005 How do I export an sql table

View 2 Replies View Related SQL Server 2000 Enterprise Manager Error Nov 27, 2007 Hi Guys wondering if you can help me. This is on SQL Server 2000MDAC 2.81.1128.0Windows 2000 SP4IIS Our Connection string looks like the following: Session("Conn") = "DRIVER={SQL Server};SERVER=DS20021218001;DATABASE=ODB;UID=webUser;PWD=***Any ideas on where to go next? 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

Enterprise Manager Turns SQL Server Service Manager Off How Do I Enter NULL In A Table Cell In The Enterprise Manager UI For Table Data Entry?

I am working with SQL2000 developers version with SP4. We get the message on all 4 servers whether or not they connect to a database on the SAN or on another stand alone server. There are no interesting messages in the event viewer. I also check another database andthoses display the table names in the SQL statements correctly.

The time now is 03:15 AM. No other table in our DB causes this problem. Process Exit Code4. this content No, create an account now.

Thanks. The form pops up and no rows appear. Home | Weblogs | Forums | SQL Server Links Search: Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About Please start any new Hope this works.

Colleagues with other installations do not get the error, and their systems return the rows correctly. ANy ideas? So I completly shut down my machine and then started it back up, but still go the same message. Error source: Microsoft OLE DBProvider for ODBC Drivers Help file: Help context: 0DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun OnStart:DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish:DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:DTSStep_DTSDataPumpTask_3 DTSRun OnError: DTS...

Any help will be greatly appreciated.Thanks View 2 Replies View Related Enterprise Manager Launch Error Mar 15, 2004 Not sure what has caused this to suddenly happen, but each time I Last, can you point me to a good resource for investigating problems of this kind, such as a knowledge base (other than Microsoft's TechNet)? Post #213873 « Prev Topic | Next Topic » 17 posts,Page 1 of 212»» Permissions You cannot post new topics. 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

Terms of Use. 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: 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: