Ok, Im a noob at SQL. I have training material that requires the
Adventureworks database. How exactly do I get it to show up in the db list?
I've tried to attach it, I've uninstalled, and reinstalled the sample db's.
According to KBs online, I should get the option to attach it during
installation if doing a post SQL install of the sample dbs. I never get this
option. I get an error trying to attach it within managment studio, the
errors state:

Could not find row in sysindexes for database ID 11, object ID 1, index ID
1. Run DBCC CHECKTABLE on sysindexes..

and,

Error: 602, Severity: 21, State: 50

Everything is green on the install. Im sure Im just not doing something
correctly or in the right order. Thank you for any information.

Hi Ron,
This message occurs when you try to attach a database that is created on a
higher version of SQL Server (e.g. SQL Server 2005) on an older version of
SQL Server.
Even though you installed SQL 2005, you likely have a version of SQL Server
2000 on your machine that is the default instance. Be default, SQL Server
Management Studio connects you to the default instance. To verify the
version of SQL Server you are connected to, execute the following statement:

SELECT @@VERSION

If you see that it refers to SQL Server 2000, you just need to connect to
your instance of SQL Server 2005 that you installed. You can do this in
Management Studio.
1. From the Object Explorer, click Connect.
2. In the Connect to Server dialog box, select "Browse for more" from the
Server name drop-down box.
3. From the Browse for Servers dialog, expand Database Engine. It should
list the available instances of SQL Server for you. Select your instance of
SQL Server 2005.

Once you have connected to your instance of SQL Server 2005, you shouldn't
have any problems attached AdventureWorks.

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of SQL Server 2005 Books Online from
http://technet.microsoft.com/en-us/s.../bb428874.aspx
Download the latest version of SQL Server 2008 Books Online from
http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx

"Ron" <Ron (AT) discussions (DOT) microsoft.com> wrote

I also have windows 7 x64 but my problem is different

SQL Server Setup has encountered the following error:

'', valor hexadecimal 0x08, ? um caractere inv?lido. Linha 1, posi??o 151.

i really don't know what to do,I've tried all the versions and nothing, always this same error
PLEASE HELP!!!



Gail Erickson [MS] wrote:

Hi Ron,This message occurs when you try to attach a database that is created
05-nov-09

Hi Ron,
This message occurs when you try to attach a database that is created on a
higher version of SQL Server (e.g. SQL Server 2005) on an older version of
SQL Server.
Even though you installed SQL 2005, you likely have a version of SQL Server
2000 on your machine that is the default instance. Be default, SQL Server
Management Studio connects you to the default instance. To verify the
version of SQL Server you are connected to, execute the following statement:

SELECT @@VERSION

If you see that it refers to SQL Server 2000, you just need to connect to
your instance of SQL Server 2005 that you installed. You can do this in
Management Studio.
1. From the Object Explorer, click Connect.
2. In the Connect to Server dialog box, select "Browse for more" from the
Server name drop-down box.
3. From the Browse for Servers dialog, expand Database Engine. It should
list the available instances of SQL Server for you. Select your instance of
SQL Server 2005.

Once you have connected to your instance of SQL Server 2005, you should not
have any problems attached AdventureWorks.

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of SQL Server 2005 Books Online from
http://technet.microsoft.com/en-us/s.../bb428874.aspx
Download the latest version of SQL Server 2008 Books Online from
http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Windows Forms .NET Creating an Owner-Drawn Menu
http://www.eggheadcafe.com/tutorials...et-creati.aspx

i also have windows 7 x64 but my problem is different

SQL Server Setup has encountered the following error:

'', valor hexadecimal 0x08, ? um caractere inv?lido. Linha 1, posi??o 151.

i really don't know what to do,I've tried all the versions and nothing, always this same error
PLEASE HELP!!!



Gail Erickson [MS] wrote:

Hi Ron,This message occurs when you try to attach a database that is created
05-nov-09

Hi Ron,
This message occurs when you try to attach a database that is created on a
higher version of SQL Server (e.g. SQL Server 2005) on an older version of
SQL Server.
Even though you installed SQL 2005, you likely have a version of SQL Server
2000 on your machine that is the default instance. Be default, SQL Server
Management Studio connects you to the default instance. To verify the
version of SQL Server you are connected to, execute the following statement:

SELECT @@VERSION

If you see that it refers to SQL Server 2000, you just need to connect to
your instance of SQL Server 2005 that you installed. You can do this in
Management Studio.
1. From the Object Explorer, click Connect.
2. In the Connect to Server dialog box, select "Browse for more" from the
Server name drop-down box.
3. From the Browse for Servers dialog, expand Database Engine. It should
list the available instances of SQL Server for you. Select your instance of
SQL Server 2005.

Once you have connected to your instance of SQL Server 2005, you should not
have any problems attached AdventureWorks.

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of SQL Server 2005 Books Online from
http://technet.microsoft.com/en-us/s.../bb428874.aspx
Download the latest version of SQL Server 2008 Books Online from
http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
..NET PropertyGrid Control - ListBox, ComboBox, and Custom Classes
http://www.eggheadcafe.com/tutorials...d-control.aspx

Yes, I do have SQL 2000 installed. I executed the SELECT @@VERSION
statement and I get Microsoft SQL Server 2000 - 8.00.194 (Intel X86.........
I followed your instructions, but I have no options to connect to a SQL 2005
instance. Is this because they are both a default instance, and one should be
a named instance?

"Gail Erickson [MS]" wrote:

Reinstalled with a named instance, that did the trick. Thank you very much
for you insight.

"Ron" wrote: