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

An Unexpected Error Happened During This Operation Sql 2000

The form pops up and no rows appear. and given the accounts all the permissions I can dream up. View 8 Replies View Related Problems Running Enterprise Manager And Service Manager Jul 20, 2005 On one of our machines, all of the SQL Server 2000components except for the main Server I have installed SQL Server 2005 Express and SQL ServerManagement Studio Express. http://dukesoftwaresolutions.com/an-unexpected/an-unexpected-error-happened-during-this-operation-sql-server-2000.html

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 View 1 Replies View Related SQL Server Enterprise Manager.MSC Jun 18, 2001 Does anyone know how to recreate the SQL Server Enterprise Manager.MSC file? I just did a reinstall and added service pack 3a ( previously on sp3). sax1964 New Member All, I'm using SQL Server 2000 on w2k server. hop over to this website

I just set this machine up in th last week and installed all Win2K3 patches and then installed SQL2K and SP3a. It's quick & easy. Post your question and get tips & solutions from a community of 418,422 IT Pros & Developers. Privacy Policy.

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. We have clustered Dell PowerEdge 2850 servers w/ 4GB Ram, connecting to a CX300 SAN.

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 Enterprise Manager SQL Server Enterprise Manager Access How Does Enterprise Manager Connect To SQL Server? Any suggestions[?] sax1964, Jan 27, 2006 #2 Luis Martin Moderator How about to do the same from other PC with sql tools? http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=148196 The only problem occurs when I use Enterprise Manager, I right click on a table in the Northwinds database to open table and return all rows.

Aug 10, 2006 Hi Sqlserver experts,I use the SQL Server enterprise manager of MSSQL 2000 regularly.I'm often annoyed by the automatic blanking of the table views.If this happens then mostly with The form pops up and no rows appear. You cannot edit other posts. So I completly shut down my machine and then started it back up, but still go the same message.

You cannot post new polls. http://www.sql-server-performance.com/forum/threads/an-unexpected-error-happened-during-this-operation.6925/ Thanks. I just set this machine up in th last week and installed all Win2K3 patches and then installed SQL2K and SP3a. Sep 9, 2005 I have a column defined as smalldatetime.

It looks like I may have to return the server (under warrenty) unless someone can advise on a fix. navigate here They want me to boot one of my clustered servers into VGA mode and try the same process on a non-clustered database. Might this be an IE security patch disallowing some connectivity ? --Frank -- Message posted via http://www.sqlmonster.com A number of people seem to have had similar issues - if you Google 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?

Luis Martin Moderator SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this 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 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 Check This Out You cannot delete your own topics.

You cannot delete your own events. i dont know what the problem is. [uote user="RobertRFreeman"] I try to add a new database diagram to sql server 2000 using Enterprise Manager and I get this error: SQL Server 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 ErrorCan anyone tell me what

Terms of Use.

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 I tried exporting one table then importing it into another but it wont transfer any of the actual data. 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 Can I Download The Enterprise Manager For SQL Server?

As far as I know this has never worked on this installation. SQL Server > SQL Server Tools Question 0 Sign in to vote I try to add a new database diagram to sql server 2000 using Enterprise Manager and I get this 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 this contact form Any help would be appreciated.

Everything was installed fine without any errors. Everytime I load up enterprise manager the service manager turns off. Any other ideas? 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

Our servers were built from the Dell Factory and all we did was load SQL on them and cluster them. Make a suggestion Dev centers Windows Office Visual Studio Microsoft Azure More... I have also tried to open this via mmc and get the same.I have an attached a screen shot of the error.