The AdventureWorks DB Design
Dec 20, 2005Is it a good template for, say, limited CRM applications ?
View 1 Replies
ADVERTISEMENT
AdventureWorks In Vwd
Oct 28, 2007Goodday all
I wonder if anyone can help.
I'm trying to work through a tutorial using a sample database , Adventureworks. When I drag a table "Address" onto my page to set up a grid veiw , and start debugging , the error message reads "invalid object name Address"
On the database explorer the table has (Person) next to the name Address. This I think has something to do with the schema. I cannot get it right to change anything , no matter what I try. I have used this data base in a windows application and it works fine. No (Person ) attached to the table name.
Has anyone got any ideas.
Thanks
Rob
AdventureWorks
Sep 6, 2007I've download and installed the sample database but the Server can't see it .. it doesn't appear in the User databases. I installed using the defaults. Anyone ha d the same problem and solved it?
Adventureworks Installation
Sep 16, 2007I downloaded and installed the .msi from codeplex. After installation I open SQL Server Management Studio but don't see AdventureWorksDB in the list of databases. How is this possible? Should I not be seeing this new database? Do I have to do something else?
View 1 Replies View RelatedAdventureWorks Database
Mar 21, 2007I'm interested in AdventureWorks querying. I thought of get a start from someone specifically on this db.
View 4 Replies View RelatedAdventureWorks Database
Jun 3, 2007I am unable to attach the AdventureWorks database in management studio. I installed it when I installed SQL Server 2005 but can not find the mdf or ldf files anywhere. When I inserted the installation disks again to do a custom instal, and selected AdventureWorks, the response came back that it was already installed. What do I need to do to be able to attache this db in the management studio?
Many thanks in advance for your help.
Need A Query In AdventureWorks
Apr 11, 2008Display all EmployeeName,EmployeeTitle,ManagerName,ManagerTitle.
View 9 Replies View RelatedCannot Install AdventureWorks
Apr 19, 2007I downloaded and installed SQL Server 2005 express Edition with advanced services.
My attempt to install the AdventureWorks from "Add or Remove Programs" failed for I was not able to see the "Documentation, Samples, and Sample Databases" node from "Feature Selection".
After reading a little bit I discovered that I had to download AdventureWorks from http://msdn2.microsoft.com/en-us/librry/ms144235.aspx
First I downoladed and installed SqlServerSamples.msi and then AdventureWorksDB.msi however I cannot find AdventureWorks.mdf to attach to my instance? Inside the folder C:Program FilesMicrosoft SQL ServerMSSQ.1MSSQLData I have AdventureWorks_Data.mdf and AdventureWorks_Log
Can you please help?
thanks
Rick
AdventureWorks Owner
Aug 15, 2006Hi,
I've installed AdventureWorks, attached it to SQL Express and wanted to see its Database Diagrams. When I click on the Database Diagrams, I get this error message:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
-----------------------------------------------------------
I really see that in properties for this database there's no owner, while if I do
sp_helpdb 'AdventureWorks'
It shows that the owner is 'IDB-SERVMichael' , which is my user.
I further tried to set this user as an owner in AdventureWorks properties-files window (where it showed no owner), but it says :
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Set owner failed for Database 'AdventureWorks'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Set+owner+Database&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred in SMO. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476
------------------------------
The login 'IDB-SERVMichael' does not exist on this server.
Are all these bugs, or did I miss something?
Please, help
Thanx a lot !!!!
Installation From AdventureWorks
May 11, 2007Hallo
I have reinstalled then SQL-Server.
Now I could found the Script instawdb.sql.
Our version from SQL Server 9.0.2047
and the language is German.
From where could download the script.
Thanks for your help.
Thomas
AdventureWorks DB Question
Jun 12, 2006Hi, I have been looking at the Adventure works DB diagram and I am confused about the relationship that employees, customers and individuals has with contact i.e. a 1-1, 1-many or many-many relationship. Also why is it broken down like that.
Thanks,
Nadim.
AdventureWorks Problem
Jun 5, 2008When I browse the http://localhost/storecsvs/
I always keep on getting this error on my browser
Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request. Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
On my Event Viewer i keep on getting 3 errors everytime I browse the said link
1 ----
Source: ASP.NET 2.0.50727.0
Failed to initialize the AppDomain:/LM/W3SVC/1/Root/StoreCSVSException: System.IO.FileLoadExceptionMessage: Could not load file or assembly 'System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Access is denied.........
--- 1
2---
Source: ASP.NET 2.0.50727.0Failed to execute the request because the ASP.NET process identity does not have read permissions to the global assembly cache. Error: 0x80070005 Access is denied. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.---23---Source: ASP.NET 2.0.50727.0aspnet_wp.exe (PID: 412) stopped unexpectedly.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.---3
I' ve followed the installation instructions on readme_storefront.htm , the AdventureWorks DB has been properly installed and can make a query on it , AdventureWorks Analysis Services Project has been properly deployed , recompiled the StoreCSVS.sln , the IIS is properly running , I'm using WinXP SP2 and MSSQL 2005 Standard Ed SP2. The instance name of my DB is ComputerNameSQL2005 , I haven't done any changes in the *.sln file of StoreCSVS
Whats causing this error?
Thanks
From AdventureWorks To AdventureWorksDW
Feb 1, 2007
AdventureWorks and AdventureWorksDW are good samples for transaction and dw.
Is there any sample of SSIS package to load data from AdventureWorks to AdventureWorksDW? For example, I'd like to update AdventureWorksDW db everyday from transaction db.
How about if some dimensions changed, like employees, and productions?
Thanks!
-Z
Registering AdventureWorks
Jul 5, 2006The organization I work for will be converting to SQL Server 2005 in the near future so I downloaded the free 90 day trial to familiarize myself with the software. I've installed the software and my plan now is to go through the Tutorials. I need to access AdventureWorks sample database. AdventureWorks did not download upon initial setup so I've downloaded/installed it into what appears to be the correct folder: c:ProgramFilesMicrosoft SQL Server90ToolsSamples. I cannot, however, seem to locate it within SQL Management Studio. As advised by the tutorial I've tried setting up a New Server Registration but I can't seem to locate AdventureWorksDB when I'm browsing for it under the Connect to Database:' option under the "Connection Properties" tab of New Server Registration.
I am familiar with database development as it relates to MS Access but I realize this is a whole new ball of wax. Any advise would be appreciated as it relates to this problem but also any information, i.e., very basic books on learning SQL Server would also be appreciated.
Treasa
Cannot Connect To AdventureWorks Db
Jan 22, 2007All,
I am running SQL05 Dev with AdventureWorks on my desktop with local admin rights. I also have it configured to connect locally since it's a DEV version of SQL.
When I use either of the connection strings below I get the error message at the end of this post.
Thanks,
>Scott
Here are the strings:
Data source=(local); initial catalog=AdventureWorks or Data source=(SQLDEV05); initial catalog=AdventureWorks
Here is the error message:
TITLE: Microsoft Report Designer
------------------------------
A connection cannot be made to the database.
Set and test the connection string.
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
Adventureworks BillofMaterials
Oct 5, 2006In this stored procedure the quantity of the parent is not included. It
should multiply down the tree. Can someone explain how this recursive
function work?
Adventureworks Application Error
Jul 21, 2007I am using ms sql server 2005 Enterprise Evaluation Edition, and I can use the other sample dtabases, like pubs, northwind, but not adventureworksI tried diffrent ways, I am very new to this, and I try before I ask, and I had to give up, Here is what I didwhen I installed adventureworks it was like 166 mb. bigAnd when I tried to use it with visual studio, every time I want to drag a table from: data connections/adventureworks, and try to veiw it in borwser it gives me an application server error, and invalid object namewith northwind database works finethen I tried executing instawdb.sql located C:Progam filesMicrosoft SQL Server90ToolsSamplesAdventureWorks OLTP, from Sql server management studio,And it finishes with errors, and is only 122 mb. bigThis line in red:Msg 4861, Level 16, State 1, Line 1Cannot bulk load because the file "C:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATAAWDBAddress.csv" could not be opened. Operating system error code 3(error not found).and at the end this:DBCC SHRINKDATABASE: File ID 1 of database ID 6 was skipped because the file does not have enough free space to reclaim.last night I was thinking wether it might be my OS( usning windows xp), or server evalution editionDoes anybody know something about this?I already google search and only found one person with the same problem, but there was no solution posted
View 1 Replies View RelatedAdventureworks Version 631 Error
Aug 18, 2007I installed Sql Server 2005 Express Edition on an XP system this
morning and tried to attach Adventureworks, but got an error message
stating:The database 'Adventureworks' cannot be opend because it
is version 631. This server supports version 612 and
earlier. A downgrade path is not supported.Since both Sql
Server 2005 Express Edition, Management Studio, and the Adventureworks
database have all be downloaded within the past three days, I am
astonished that there is a compatibility issue. I have run
Adventureworks on other systems without problems. Any suggestions
on how to proceed?
Trying To Install Adventureworks Sample
Jan 4, 2006I've downloaded from msdn and ran the samples. It installs something, but the database tree doesn't show up in sql studio. Is there a straight forward way to do something like import or restore a adventureworks database setup?
View 1 Replies View RelatedAdventureWorks Database Question
Apr 6, 2006How can I install the AdventureWorks database on my box where C:Program FilesMicrosoft SQL Server90ToolsSamples is missing? My SQL 2005 is currently without AdventureWorks OLT. I downloaded the Enterprise trial before uninstalling SQL2005Express. Please help. Thanks.
View 4 Replies View RelatedProblem Loading Adventureworks
Apr 7, 2006new to sql 2005 express and trying to get adventureworks up and running
within studio express go file open
and get error
"There is mo editor available for C:..AdventureWorks_data.mdf
Make sure application for the file type(.mdf) is installed
I'm presumably missing something basic here
Amy help appreciated
Andrew Clark
www.majorleaguecharts.com
SQLSever Express & Adventureworks
May 2, 2006Hi All,
I am using SQLExpress and want to use some of the sample data to educate myself. however, I cannot seem to connect to the Adventureworks databse. I do not even see it within Management Studio Express. I would be grateful for advice or an article that will push in the right direction.
Matt A
Install AdventureWorks Database
Oct 8, 2007I'm not sure that I installed the AdventureWorks database when I originally installed SQL Server 2005 on my pc, but I thought I'd better go thru the tutorial and it uses AdventureWorks, so I put my CD in to install it and started the install.
When I got to the screen where you choose your components, I only checked the Sample Database selections at the bottom. Then I got a screen saying the components had already been installed. So I thought I must have installed AdventureWorks when I did the original install, but the tutorial says to go to Registered Servers and do a new Server Registration choosing the AdventureWorks database on the Connection Properties tab. But it isn't listed there when I browse the server's databases.
How can I get it installed?
NOTE: I had SQL Server installed on my C: drive, but had a major corruption issue, so I added a second hard drive to my system and installed XP on it. So my boot drive is now by G: drive, not C:. SQL Server and most of the other programs I use have been re-installed on G:. I DO have northwind.mdb & ldb files on my C: drive. Would it be easiest to just restore them to G:? Are they the AdventureWorks database?
Thanks.
Attaching AdventureWorks Database
Mar 21, 2007Today I installed SQLEXPR.EXE that I found here:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476
I made sure that I downloaded the 64-bit version.
I then wanted to download and install the Adventure Works database located here: http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
Since I am running Vista 64-bit, I downloaded and installed AdventureWorksDB_x64. It wouldn't install. I got "Access is denied" and CREATE FILE error plus several others.
I then uninstalled it and downloaded AdventureWorksDB - this is the X86 version. It installed fine.
Can anyone explain what am I missing? Thanks!
No Deployment In AdventureWorks 2008
May 22, 2008Hello,
I installed CTP 5 and the 2008 Adventure Works DW database (July edition).
I'm having trouble installing the analysis database. I open the solution in BIDS and when I'm trying to deploy, the green circle never stops (it ran for hours). I tried doing the same with SSMS & XMLA, but the result was the same - it executes forever.
Any suggestions?
How To List All The Tables In AdventureWorks With T-SQL
May 29, 2008
I guess it's possible to do that, because in SQL Server Management Studio, all things(such as Tables,Triggers, Indexes, Constraints, Keys) are displayed in the TreeView.
But I am quite don't understand how to do that with T-SQL.
thanks
Why AdventureWorks Missing LineNumber?
Apr 23, 2008Hi,
Is there anyone know why AdventureWorks.Purchasing.PurchaseOrderDetail.LineNumber column no longer exists?
Thanks,
Kenny
Could Anyone Test This On SQL2005 AdventureWorks
Nov 2, 2006SELECT TerritoryId,
[2003-01],[2003-02],[2003-03],[2003-04],[2003-05],[2003-06],
[2003-07],[2003-08],[2003-09],[2003-10],[2003-11],[2003-12],
[2004-01],[2004-02],[2004-03],[2004-04],[2004-05],[2004-06],
[2004-07]
from ( select TerritoryId,
CONVERT(CHAR(7), h.OrderDate, 120) AS theDate, d.LineTotal
FROM Sales.SalesOrderHeader h JOIN Sales.SalesOrderDetail d ON h.SalesOrderID = d.SalesOrderID
) p
pivot (
sum(LineTotal) for theDate in ([2003-01],[2003-02],[2003-03],[2003-04],[2003-05],[2003-06],
[2003-07],[2003-08],[2003-09],[2003-10],[2003-11],[2003-12],
[2004-01],[2004-02],[2004-03],[2004-04],[2004-05],[2004-06],[2004-07])
) pvt
order by TerritoryId
The code is based on a sample from Pro SQL2005 (Apress). The book is great BTW.
While modifying it for a testdrive I think I made an error but where. Inner select executes in less than a second. However applying the pivot it takes 5-6 seconds.
Total row count is around 121K. All it does with PIVOT is to sum and crosstab. If I do this taking raw data from inner select outside and do pivoting myself it's much faster. So is it my code here or PIVOT is really an unoptimized addition?
TIA
Permissions And Access To AdventureWorks
Apr 4, 2007I have downloaded the Express Edition of SQL Server 2005 to try to learn the software to take the MCTS test for certification. I have installed the software and the SMS. I have downloaded the AdventureWorks database files and installed everything as directed. I use Windows authentication to log in (it's my own home PC). I have followed the instructions to attach the database to the instance I am using.
The problem I'm having is in trying to run examples from the book I'm using on the database. For example, I'm trying to run a simple query like "SELECT * FROM dbo.DatabaseLog;" When I click execute, I keep getting this message:
"
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.DatabaseLog'.
"
When I look at the Object Explorer pane, I can clearly see the table and see that I am spelling it correctly.
I have set my login up as the owner of the database and when I try to set up permissions on the table, I only see the roles [user] and [guest]. I tried setting up permissions for both, but that didn't help.
What am I doing wrong?
Thank you.
Eric S. Bauman
Installing The AdventureWorks Database
Jul 27, 2006I've downloaded and installed the Adventure works database
I follow the instructions give here
http://msdn2.microsoft.com/en-us/library/ms310325.aspx
but this command here:
exec sp_attach_db @dbname=N'AdventureWorks', @filename1=N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorks_Data.mdf', @filename2=N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorks_log.ldf'
results in this error:
"unable to open physical file,................................................. the system can't find the specified file."
AdventureWorks_log.ldf + AdventureWorks_Data.mdf ...................don't exist at this location:
c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
i'm thinking of reinstalling the whole adventure works DB.
any ideas please
How Do I Get AdventureWorks To Show In Sql2005.
Jun 18, 2005How do you make the AdventureWorks sample show up (June ctp)? I already installed it using the msi file:
View 11 Replies View RelatedCannot Install AdventureWorks Database.
Aug 6, 2007I downloaded AdventureWorksDB from the CodePlex website and tried to install it. When the install program tried to attach it to SQLEXPRESS, it gave the error (below). I've also tried attaching the database directly using the SQL Management Studio and got exactly the same error.
I'd never heard of having incompatible database versions for SQL Server before. Am I missing a patch for SQLEXPRESS or ????. Thanks.
=================================================================
The database 'AdventureWorks' cannot be opened because it is version 631. This server supports version 612 and earlier. A downgrade path is not supported.
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)
------------------------------
Server Name: HP-MEDIACENTERSQLEXPRESS
Error Number: 948
Severity: 20
State: 1
Line Number: 1
Enable Table Dependency In AdventureWorks Db?
Feb 20, 2007I have been having trouble with enabling table dependencies using the aspnet_regsql utility on the Product table in the AdventureWorks database. It is in the Production in the normal dbo schema. When I run the utility to enable the table dependency for SQL cache notifications it fails because it tries to prefix the reference to the table with dbo.Now I know it just adds a trigger for INSERT, UPDATE and DELETE where it runs a stored procedure to update the main table dependency table, but if I do that manually it requires that the trigger also run in the Production schema. I am not sure if this will still work with SQL query notifications.http://msdn2.microsoft.com/en-us/library/ms124719.aspx Please reply if you can help.
View 2 Replies View Related