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

An Unexpected Error Happened During This Operation Sql 2000

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 Nothing wrong with the server side or any permission settings) 1. Barring that, can anyone suggest some general steps I might take to possibly eliminate this problem without knowing the cause? Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? his comment is here

To start viewing messages, select the forum that you want to visit from the selection below. and given the accounts all the permissions I can dream up. Does the Client Network Utility affect it? What's it doing, connecting toevery database? http://forums.databasejournal.com/showthread.php?18495-SQL-msg-%22an-unexpected-error-happened-during-this-operation%22

I don't know if this is causal or coincidental yet. I am debating as to whether or not I should uninstall SQL Server 2000 and reinstall it? Kevin Tall Post #200198 ND-215452ND-215452 Posted Tuesday, July 12, 2005 4:49 PM SSC-Enthusiastic Group: General Forum Members Last Login: Friday, March 13, 2009 6:06 AM Points: 139, Visits: 2 I think

Any other ideas? I also check another database andthoses display the table names in the SQL statements correctly. 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 Query Analyzer works sometimes and sometimes doesn't.

The SQL ServerManagement Studio Express menu has 3 items on it. You cannot delete your own posts. The server has 2GB of RAM.In the end i would like to add that no error is registered in the event viewer neither in SQL Server error file.Thank you Marianna Post http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=148196 When the SP 2 box connects to the SP 3 box, it does not.So it seems to be a problem with the Enterprise Manager GUI and not the underlying DBMS.Brian Post

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. Terms of Use. Any update to this would be appreciated. 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

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 http://www.sql-server-performance.com/forum/threads/an-unexpected-error-happened-during-this-operation.6925/ 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 sp_cycle_errorlog tried, no help. But everytime i turn it back on and try to connect again it shuts it off and around and around we go.

We've got lots of great SQL Server experts to answer whatever question you can come up with. http://crearesiteweb.net/an-unexpected/an-unexpected-error-occurred-during-a-vss-operation.html Sep 9, 2005 I have a column defined as smalldatetime. ThanksJimmy View 10 Replies View Related DTS Designer Error While Opening Locally From Enterprise Manager Nov 7, 2007 Hi, I am getting following error message while opening DTS package, "No provider any ideas ???????Cheers View 9 Replies View Related Enterprise Manager Causing Memory Error Jun 13, 2001 When I try open a table in Enterprise Manager, I am getting the following error:The

Say i have entered a date (all is well), and now i want to remove that entry and go back to NULL (after the datevalue has been committed, different entry session, Jun 12, 2001 Can anyone tell me how Enterprise Manager connects to SQL Server? 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 http://crearesiteweb.net/an-unexpected/an-unexpected-error-happened-during-this-operation-sql-server.html View 1 Replies View Related Need Location Of MS SQL Server Enterprise Manager Apr 20, 2000 I've looked on Microsoft.com for the download location for MS SQL Server Enterprise Manager and

Developer Network Developer Network Developer :CreateViewProfileText: Sign in MSDN subscriptions Get tools Downloads Visual Studio MSDN subscription access SDKs Trial software Free downloads Office resources SharePoint Server 2013 resources SQL Server Log in :: Register :: Not logged in Home Tags Articles Editorials Stairways Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us 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.

Our servers were built from the Dell Factory and all we did was load SQL on them and cluster them.

You cannot delete other events. I can run SQL Analyzer and run "select * from table_name". But I know that the databases are exactly the same and the SP 3 box is much, much more powerful.More specifically, when the SP 3 box connects to the SP 2 I have installed SQL Server 2005 Express and SQL ServerManagement Studio Express.

you can get SP4 from the microsoft webdite for free Narayanan Sunday, July 09, 2006 11:06 PM Reply | Quote 0 Sign in to vote Hello: Narayanan I am getting the I tried re-installing SP4, but this did not fix it. 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 http://crearesiteweb.net/an-unexpected/an-unexpected-error-happened-404-unknown-error.html 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.

Simon Jul 23 '05 #2 This discussion thread is closed Start new discussion Replies have been disabled for this discussion. You cannot vote within polls. Nothing seems to work. As far as I know this has never worked on this installation.

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 You cannot post events. Technet found two documents but not related to the problem. View 4 Replies View Related Error Opening Up Microsoft Sql Enterprise Manager Feb 26, 2008 HiI am getting an error when i try to open MSEM.

When I tried to enter Enterprise Manager again, I got an error message "MMC Cannot Open The Selected File". This once happend to me 2-3 weeks ago when i unstall MS SQL 2000 on my machine and re-install it, later then when i used EM to open table rows from You cannot edit your own events. 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.

And the enterprise manager can't connect to the local database. They want me to boot one of my clustered servers into VGA mode and try the same process on a non-clustered database. The version I am using is MS-SQL 7.0 with SP 1 on NT. Trying to create a trigger on a table called ACCOUNT owned by SYSDBA.