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

An Unexpected Error Happened During This Operation Sql 2000

I can successfully run Select in Query Analyser against the same servers/dababases.Today is the first day it started. I don't feel like retyping all 6000 records and I need somehow duplicate this table ... When you click on any row the first column called "Column" a dropdown shows all the filed names of that particular table.This feature used to work fine untill recently wherein when I also check another database andthoses display the table names in the SQL statements correctly. check over here

I just noticed today that I cannot view table data or use the Query part of EM. Any other ideas? This error occurs also when recreating the db project. 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,

Any help would be appreciated. All Rights Reserved. And as far as i know i can't connect to a certain database. I have worked previously in Sql Server 2000.

Nothing wrong with the server side or any permission settings) 1. Yesterday, when we tried to do this, we got the following message: An Unexpected Error happened during this operation. [Query] - Query Designer encountered a Query Error: Unspecified Error Can anyone Sep 9, 2005 I have a column defined as smalldatetime. Can I Download The Enterprise Manager For SQL Server?

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 Enter prise Manager is working but In a servergroup, a particular server is not opened(Expand). View 1 Replies View Related Problem In Enterprise Manager When I Am Opening DB Mar 16, 2005 helloI Detached the user default database from the server (Using EM) and when i These fields can not be edited eitther from MSAccess nor Enterprise Manager.What can be done on the table, resp.

Query Analyzer works sometimes and sometimes doesn't. Sometimes I get through ok and other times I get the above error.Is this because the hosting company has too many accounts on this server? I can't find the solution..Please help..Much regards..J.JansmaThe netherlands View 1 Replies View Related SQL Server Enterprise Manager Access Jan 17, 2006 How do I go about accessing the SQL Server Enterprise It shows the error as cannot open user default database, Login failed, i entered in EM using sa login.Please any one can help me in this regards.thanx in advance.byyas View 1

View 2 Replies View Related Home Submit Resource Tracker Forum Advance Search Privacy Policy| Terms of Use & Service| Contact Us| Copyrights Notice Copyrights 2005-15 www.BigResource.com, All rights reserved

page Might this be an IE security patch disallowing some connectivity ?--Frank--Message posted via http://www.sqlmonster.com View 1 Replies View Related How To Switch Off Automatic Blanking Of Table Views In Enterprise Manager The physical errorlog file is in c:mssql7log. 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)

If I try to use Enterprise Manager to open a table using the return rows command, I get the following error "An unpected error happened during this operation" Reinstalling the client check my blog 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 Reissue thestatement after the current backup. Thank for your help Nelsoh Hincapie A.     Monday, September 25, 2006 4:20 PM Reply | Quote 0 Sign in to vote Hi,   Solution- Re-install the Enterprise Manager again

And the enterprise manager can't connect to the local database. Post #213873 « Prev Topic | Next Topic » 17 posts,Page 1 of 212»» Permissions You cannot post new topics. View 2 Replies View Related Sql Server Enterprise Manager Aug 22, 2007 What to I query in TSQL to check the transaction log size.... http://svbuckeye.com/an-unexpected/an-unexpected-error-happened-during-this-operation-sql-server.php We have escalated this problem to Dell and Microsoft.

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: When Iright click a table and select Open Table->Return All Rows it gives me anerror dialog "An unexpected error happened during this operation". 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

I also check another database andthoses display the table names in the SQL statements correctly.

The SQL agent is running. You cannot send private messages. The form pops up and no rows appear. View 1 Replies View Related Error Returning Rows Using Enterprise Manager In SQL 7 Jan 15, 2001 Lately I noticed that I cannot return any rows using enterprise manager.

I have a single named instance. I just set this machine up in th last week and installed all Win2K3 patches and then installed SQL2K and SP3a. Privacy Policy. have a peek at these guys Is it some kind of setting in enterprise manager.All the info would be appreciated.TaN View 2 Replies View Related Unspecified Error Opening Table(s) In Enterprise Manager Sep 21, 2000 Greetings:We have

The SP 3 box has the error and the SP 2 box does not. Glory- , ?:) TCP/IP? :) ? 13 07, 10:12[4260023] | Re: An unexpected error We have a number of pages that query this table. 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.

Technet found two documents but not related to the problem. We've restricted the ability to create new threads on these forums. 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