April 30, 2009 at 11:20 am
Of the multiple problems I;ve run into with trying to get the sample DB from Microsoft called Adventureworks installed and running (you'd think Microsoft didn't want people to use the thing based on how hard they've made it to get up and running) the one item that's proven to be the biggest pain so far is the Case Sensative Collation that the DB is set to use.
I can't change the DB's Collation to a case insensative one because multiple objects of varying types (consisting of UDF's, columns, tables, views & more) were created with the WITH SCHEMABINDING option. If it were just a few I;d manually edit them but there are more then a hundread of these objects.
Anyone know an easier way to change the collation of the DB?
I'm also curious if anyone has tried to setup the Adventureworks sample DB and not had problems? It's amazing the contrast etween the new sample DB's and the old ones from Microsoft. I was able to attach and get up & running both the Northwinds & the PUBS sample DB's in no time. I spent more time just getting the AdventureWorks DB attached let alone address any of the otehr issues I've run into with it.
ANy input would be greatly appreciated!
Kindest Regards,
Just say No to Facebook!April 30, 2009 at 3:03 pm
Hi
I think you downloaded the wrong version 😉
Follow this link and download the "CI" databases:
http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004
Greets
Flo
April 30, 2009 at 3:24 pm
the one item that's proven to be the biggest pain so far is the Case Sensative Collation that the DB is set to use.
That would mean your server collation is case sensitive because I have run AdventureWorks from 2000 to 2008, there are issues with 2008 installation because it require enabling Filestream in your SQL Server 2008 installation which is disabled by default. In 2005 I installed both the OLTP and OLAP databases without any issues in three different boxes based on needs.
Kind regards,
Gift Peddie
April 30, 2009 at 4:38 pm
The only problem that I have ever had with AdventureWorks is finding the kits. It was crazy how hard it used to be to find the dang things. It's easier now at codeplex, but still much harder than just going to Microsoft and downloading say, SP1. And now that it is at codeplex, folks keep getting the 2008 version when they want the 2005 one.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 1, 2009 at 6:40 am
Well, another problem that most people don't notice is that they change the bloody thing, regularly, and don't tell you that they did it. I've been using it as a sample db for the books I've been working on for almost two years now. I can't tell you how many times I've carefully worked out a certain behavior using a very particular query only to have the bloody thing stop working because the latest version has slightly different data than the last one and the statistics are now different.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 7, 2009 at 9:11 am
Gift Peddie (4/30/2009)
the one item that's proven to be the biggest pain so far is the Case Sensative Collation that the DB is set to use.
That would mean your server collation is case sensitive because I have run AdventureWorks from 2000 to 2008, there are issues with 2008 installation because it require enabling Filestream in your SQL Server 2008 installation which is disabled by default. In 2005 I installed both the OLTP and OLAP databases without any issues in three different boxes based on needs.
The server is not set to a case sensative collation but I do think I may have an older/wrong version as another has pointed out. Even if that is the case I'm still suprised at how difficult MS has made it to use these newer sample DB's when compared to what was required to use the older stand bys; PUBS & NORTHWINDS.
Kindest Regards,
Just say No to Facebook!May 7, 2009 at 5:12 pm
If you don't have case sensitive collation are you running BIN collation because BIN is the fastest sort but also case sensitive by default. And yes I agree these databases needs to be taken from Microsoft so anybody can use them as needed.
Kind regards,
Gift Peddie
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply