I've run into this before with SQL 7 and fixed it by installing SQL7 SP3 on the client and server. I know you are using 2000 tools, but perhaps you are connecting to a SQL7 server? If so, try SP3 on the server.
-Cameron -------------------- Cameron Childress elliptIQ Inc. p.770.460.1035.232 f.770.460.0963 -- http://www.neighborware.com America's Leading Community Network Software > -----Original Message----- > From: James Taavon [mailto:[EMAIL PROTECTED]] > Sent: Saturday, January 12, 2002 5:29 PM > To: SQL > Subject: RE: Enterprise Manager Error > > > Bob, I wish that was the problem. Working within the Ent. Mgr. > environment, > I right click on any table and select "Open Table" and then either return > all rows, return top or query. All three give me that error. In the past I > was prompted for password, but now I just get the error. It is very > frustrating. I know it is not my user profile since I have tested that on > other machines and it works fine. It seems to be more of an application > error, but then how come re-install does not fix it? Do I have > some sort of > corrupt file that needs to removed? I dont know. Any more help would be > appreciated. > > Thanks, > James > > -----Original Message----- > From: Bob Imperial [mailto:[EMAIL PROTECTED]] > Sent: Saturday, January 12, 2002 3:25 PM > To: SQL > Subject: Re: Enterprise Manager Error > > > Just a thought, how many records are you trying to snag? > Have you tried to grab just a few as a process of > elimination: SELECT top 50* just to see if it's crapping out > on the shear number of recs? I run into similar things when > I have a table with massive amounts of data, just doesn't > any records for me though. My 2 cents worth > > Bob > > On Thu, 10 Jan 2002 14:43:36 -0500 > James Taavon <[EMAIL PROTECTED]> wrote: > > Hey all, > > > > I have been using SQL 2000 Client without a problem until > > the other day. > > When I try to return all rows from a table I get an > > Unknown Error: 800401F9. > > I have uninstalled and re-installed with no luck. Anybody > > got any ideas what > > cold have casued this to happen? > > > > James > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
