Re: Got an Exception error - still

Tech-Archive recommends: Fix windows errors by optimizing your registry

It's possible you just installed the SQL 2005 tools. That would give you
Management Studio and an item in the Start Menu. Some people intentionally
just install the tools so it is considered a normal operation.

Look at your services list to see if the SQL 2005 service is listed. If so,
you'll can just register the SQL2005 server in SSMS. If not, you'll have to
re-install and make sure you don't just choose the tools.

Do you know what edition of SQL 2005 you were trying to install?

--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com


"Henry Jones" <henry@xxxxxxxx> wrote in message
news:%23Pg67Z%23DHHA.4928@xxxxxxxxxxxxxxxxxxxxxxx
I ran the query and this is what came back

Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)


so it does look like I have SQL 2000 on the PC, but 2005 Management
Studio. So why don't I have SQL 2005 on my PC? If Management Studio is
alive and well shouldn't I have both 2000 and 2005?

In the Start Menu, I have "Microsoft SQL Server 2005" so I thought it was
installed.

Now I am more confused.



"Gail Erickson" <gaile@xxxxxxxxxxxxx> wrote in message
news:u1jsEbpDHHA.4256@xxxxxxxxxxxxxxxxxxxxxxx
Have you considered that perhaps your copy of the Adventureworks files
are corrupt?

Error 602 can certainly indicate database corruption, but it is also
returned when you try to attach a database that is a higher version than
the instance of SQL Server you're connect to.

I think I have SQL 2005 Express and SQL 2005 on my PC.
You need to find out what version you're actually connecting to. My guess
is you're connected to an instance of SQL Server 2000.

What do you get when you run this query ?
SELECT @@VERSION

Gail Erickson [MS]

"Arnie Rowland" <arnie@xxxxxxxx> wrote in message
news:eNNwo3oDHHA.4280@xxxxxxxxxxxxxxxxxxxxxxx
Have you considered that perhaps your copy of the Adventureworks files
are corrupt?

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to
the top yourself.
- H. Norman Schwarzkopf


"Henry Jones" <henry@xxxxxxxx> wrote in message
news:uHg4HjoDHHA.4312@xxxxxxxxxxxxxxxxxxxxxxx
On the screen to attach the database, the only choice is adding the
mdf. Once the mdf is chosen, both the mdf and ldf files appear below in
thebox.

I still get the error


"Jay B" <jayB@xxxxxxxxxxx> wrote in message
news:rz39h.37$UA5.32@xxxxxxxxxxxxxxx
there are 2 files that make up a database, the mdf and the ldf.
they act as a set.

Henry Jones wrote:
I got an error when I tried to attach to the database in the folder
that it was installed in.

"Could not find row in sysindex for database ID 9, object ID 1, index
ID 1. Run DBCC CHECKTABLE on sysindexes. Could not open new database
"AdventureWorks". CREATE DATABASE is aborted. (Microsoft SQL Server,
Error: 602)


"Jay B" <jayB@xxxxxxxxxxx> wrote in message
news:cp09h.26$UA5.8@xxxxxxxxxxxxxxx
simple. databases can be in any folder on your computer.

with that said, simply go to the databases node in the tree, right
click and use the ATTACH option, then sepecify the folder where you
have the adventureworks. if you want to move it, then move it
before attaching.



Henry Jones wrote:
I went to Microsoft downloads and downloaded the AdventureWorks.msi
file. When it ran, it says that it installed AdventureWorks.

I think I have SQL 2005 Express and SQL 2005 on my PC. There are
two directories: C:\Program Files\Microsoft SQL Server\MSSQL\Data
and C:\Program Files\Microsoft SQL Server\MSSQL.1\Data

The AdventureWorks has been placed in the C:\Program
Files\Microsoft SQL Server\MSSQL.1\Data directory, but when I bring
up SQL Server Management Studio, I don't see AdventureWorks. The
databases I have associated with this are all under the C:\Program
Files\Microsoft SQL Server\MSSQL\Data directory.

How can I import the table into SQL server and why did the MSI
install put it in the wrong place.

Thanks for any guidence and help on this "day before Thanksgiving"













.

Relevant Pages

  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)
  • Re: Trying to Move Group - SQL Instance Wont Start
    ... You can do a maintenance install and add the new nodes. ... "maintaining a failover cluster" for recovery from failure scenario 1. ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... While attempting to install SP4, it comes up immediately after I ... to be on one of the nodes that can bring SQL Server online and apply SP3a, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Any help here???
    ... Well, for starters, I believe MDAC is unnecessary for .NET applications - as ... ADO.NET has its own SQL Server provider for data access. ... > trust me - all that's been done here was to install SP2 or upgrade of XP ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)