Thursday, March 22, 2012

AdventureWorks database

Is this database 'AdventureWorks' comes with SQL 2005?
I read the book 'Mastering Microsoft SQL Server 2005' by Sybex says this
comes with SQL Server 2005. But I cannot find that in the Management Studio.It is not automatically installed. You must specifically select it during a
custom install.
You might be able to get it now by just reinstalling the tools and making
sure you choose the sample databases. Otherwise you can download it from
here
http://www.microsoft.com/downloads/details.aspx?FamilyID=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:ucBHEhvLHHA.780@.TK2MSFTNGP03.phx.gbl...
> Is this database 'AdventureWorks' comes with SQL 2005?
> I read the book 'Mastering Microsoft SQL Server 2005' by Sybex says this
> comes with SQL Server 2005. But I cannot find that in the Management
> Studio.
>|||Thanks.
I downloaded the 'SqlServerSamples.msi' and installed it.
However, I looked thro' the Samples folder cannot find the AdventureWorks
database.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uBZ0s2vLHHA.960@.TK2MSFTNGP04.phx.gbl...
> It is not automatically installed. You must specifically select it during
> a custom install.
> You might be able to get it now by just reinstalling the tools and making
> sure you choose the sample databases. Otherwise you can download it from
> here
> http://www.microsoft.com/downloads/details.aspx?FamilyID=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
>
> --
> HTH
> Kalen Delaney, SQL Server MVP
> http://sqlblog.com
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:ucBHEhvLHHA.780@.TK2MSFTNGP03.phx.gbl...
>> Is this database 'AdventureWorks' comes with SQL 2005?
>> I read the book 'Mastering Microsoft SQL Server 2005' by Sybex says this
>> comes with SQL Server 2005. But I cannot find that in the Management
>> Studio.
>|||Alan T wrote:
> Thanks.
> I downloaded the 'SqlServerSamples.msi' and installed it.
> However, I looked thro' the Samples folder cannot find the AdventureWorks
> database.
You should download AdventureWorksDB.msi or AdventureWorksDBCI.msi
Razvan|||Yes, the SqlServerSamples.msi is code samples. There are separate downloads
for the sample databases, which you can see in the link I gave you are
larger files than the Samples download. You can choose to download AW in
either a case-sensitive collation or case-INsensitive.
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Razvan Socol" <rsocol@.gmail.com> wrote in message
news:1167832817.697717.13790@.48g2000cwx.googlegroups.com...
> Alan T wrote:
>> Thanks.
>> I downloaded the 'SqlServerSamples.msi' and installed it.
>> However, I looked thro' the Samples folder cannot find the AdventureWorks
>> database.
> You should download AdventureWorksDB.msi or AdventureWorksDBCI.msi
> Razvan
>|||Yes, I downloaded and now to attach the database file.
Thanks.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:evmaXQ1LHHA.5064@.TK2MSFTNGP04.phx.gbl...
> Yes, the SqlServerSamples.msi is code samples. There are separate
> downloads for the sample databases, which you can see in the link I gave
> you are larger files than the Samples download. You can choose to download
> AW in either a case-sensitive collation or case-INsensitive.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> http://sqlblog.com
>
> "Razvan Socol" <rsocol@.gmail.com> wrote in message
> news:1167832817.697717.13790@.48g2000cwx.googlegroups.com...
>> Alan T wrote:
>> Thanks.
>> I downloaded the 'SqlServerSamples.msi' and installed it.
>> However, I looked thro' the Samples folder cannot find the
>> AdventureWorks
>> database.
>> You should download AdventureWorksDB.msi or AdventureWorksDBCI.msi
>> Razvan
>sql

No comments:

Post a Comment