AdventureWorks Database
Mar 21, 2007I'm interested in AdventureWorks querying. I thought of get a start from someone specifically on this db.
View 4 Replies
ADVERTISEMENT
Database Explorer In VB Express:AdventureWorks.mdf-Files Do Not Match The Primary File Of The Database
Nov 5, 2007Hi all,
I downloaded and ran AdventureWorks.msi into my SQL Server Management Studio Express (SSMSE) one year ago.But I did not know how to attach it to my SSMSE then. Last week, I deleted it from the "Add or Remove" of Control Panel and I downloaded the new AdventureWork.msi and installed it my SSMSE. Today, I tried to use the Database Explorer of VB 2005 Express for the first Stored Procedure programming. I clicked on AdventureWorks.mdf and I got the following error: One or more files do not match the primary of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupt and should be restored from a backup. Cannot open user default database. Login failed. Login failed for user 'CENADe1enxshc'. Log file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorks_Data_log.ldf' does not match the primary file. It may be from a different database of the log may have been rebuilt previously. Please help and advise me how to correct this problem.
Thanks,
Scott Chang
Error Attaching Adventureworks Database And SSIS Training Database
Oct 4, 2006Hi there,
I got this error when i tried to attach the adventureworks database and SSIS training database.
an exception occurred while executing a transact-sql statement or batch
(microsoft.sqlserver.connectioninfo)
could not find row in sysindexes for database ID 17, object ID 1, index ID 1. Run DBCC
checktable on sysindexes.
I join join a network domain for my computer. Previously it doesnt have this problem.
AdventureWorks 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.
AdventureWorks 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 RelatedInstall 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!
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
Cannot 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
AdventureWorks Database - Cannot Access Database Diagrams
Feb 20, 2007Hi,
When I try to access the database diagrams in AdventureWorks, I get the following 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.
------------------------------
BUTTONS:
OK
------------------------------
Why is this?
All advice / help apprecuated.
Thanks
Cannot Install Database Diagrams On AdventureWorks Database
Jun 11, 2007Error Message: Database diagram support objects cannot be installed because this database does not have a valid owner.
How do I create a valid owner for the database?
Getting Table Names From AdventureWorks Database
Apr 24, 2008Hello,
I have ran into a problem when i'm getting table names in c#.
I have tried the sql command:
select name from sysobjects where type='U' order by name
So it returns the names without a problem. But when I try to access to some tables using their names (to retrieve the columns) I sometimes get the error "Invalid object name" following by the name of the table.
So I realized the if the table was not under dbo user then i would get this error.
for example: "select name from ContactCreditCard"
gives me error because in database management tool it is shown like this: Sales.ContactCreditCard
How can i fix this problem? How to get that prefix of the tables?
Thank you,
Can't Deploy AdventureWorks AS Database Using Instances Of SQL And AS
Jul 26, 2005Hi all,
View 20 Replies View RelatedSave A Copy Of Modified Adventureworks Database
Apr 21, 2008Hi
I have been working with advantureworks database and make some modifications on it.
I need to be able to have a copy of this modified adventureworks database and use it on my laptop.
How can I do this if it is possible.
What I need to do is to be able to save everything I have been working on with the adventureworks on my desktop and be able to save on my laptop and proceed without lossing information. I want to install trial version of sql server 2005 on my laptop and replace the advantureworks which came with it with the modified advantureworks I have been working on.
I am travelling this week and I would like to continue what I have been working on using my laptop. I appreciate much your quick response
Thanks
MS SQL Server 2005 -- Cant Not Attach To AdventureWorks Database
Jun 8, 2007I have MS SQL Server 2005 installed and when trying to connect to AdventureWorks DB
Downloaded AdventureWorksDB.msi file and when trying to attach recieve this error when running script ?
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
Msg 602, Level 21, State 50, Line 1
Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Then tried to attach the DB and get this
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'JKIMBLE1'. (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not find row in sysindexes for database ID 8, 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)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Is there a difference between MS SQL Server 2005 and SQL Server 2005 Express Edition
Can't Uninstall Previous Version Of AdventureWorks Database
Feb 21, 2007I want to install the new (February 2007) sample databases. The readme says any previous version must be removed by dropping the database., then running Remove from Add or Remove Programs. I've detached the database, but when I try to uninstall it I get the following message:
"Error 1309.Error reading from file: pathandfilename.mdf. Verify that the file exists and that you can access it."
What should I do.
Barry
AdventureWorks Database Not Seen By Management Studio Express CTP
Apr 19, 2006When I install AdventureWorks.db for SQL Express, it runs without errors. The database files (data and logs) are in the SQL Express 2005 data directory. However, I can not see the database in Managment Studio Express CTP. I've tried repairing and uninstall/install again. Does not help.
I have SQL Express 2005 cleanly installed. I have the pubs and Northwinds databases cleanly installed. (I was able to execute the queries that came for installing these). I can see both pubs and Northwinds in Management Studio Express CTP.
Any suggestions?
AdventureWorks Sample Database && Data Consistency
Oct 17, 2007Hi,
I'm working with the sample database called Adventure Works and I'm encountering data consistency issues :
If I sum the TotalDue for one particular territory, for one particular time window from the Sales. SalesOrderHeader table and if I try to compare the result to the LastYearSales and YTDSales from the Sales.SalesTerritory table, I don't get the same number, whatever I try. So did I miss something ?
How are the LastYearSales and YTDSales fields from Sales.SalesTerritory calculated ?
Thx,
Anissa
Trying To Select AdventureWorks Database Data From Query Analyzer - Need Help
Jan 30, 2006Hi there, I have installed Sql server 2005 developer on my machine which already has a Sql server 2000 installed on. Now i am trying to query the Sqlserver 2005 data(Ex: from Person.Address located in AdventureWorks database) in Sqlserver 2000 query analyzer:
When i try as Select * from Address it said invalid object.
But when i explored AdventureWorks database in the Management studio i see it as Person.Address!!! i don't understand what is a Person in Person.Address??? any clues on this?
So as a test when i ran select * from Person.Address it did work and i saw the results in query analyzer.
Can any one help me understand about this confusion?
Thanks-L
Adventureworks Db And Dw Not Showing Up In Management Studio Database List
Jul 23, 2007I've installed both the AW db and dw off the MS download. I see the db in the directory I use for other databases, the dw doesnt seem to want to go where I tell it. Anyway, when I connect to my instance of sql (developer's) I dont see the AW db.
View 1 Replies View RelatedAdventureWorks Database Not Showing Up Management Studio Express
Jul 5, 2006After installing the Adventure works database samples they do NOT show up in Management Studio Express???
I have done a clean install of SQL Server Express 2005 SP1 with Advanced services.
How Can I Attach AdventureWorks Database To SQL Server Management Studio Express?
Sep 25, 2006Hi all,
I just downloaded AdventureWorks_Data.mdf, AdventureWorks_Data.ldf, AdventureWorksDW_Data.mdf, and AdventureWorksDW_Data.LDF files to the C:Program FilesMicrosoft SQL ServerMSSQL.1|MSSQLData folder of my Windows XP Pro PC. I tried to attach the AdventureWorks database in my SQL Server Management Studio Express in the following way: I clicked on SQL Server 2005 Express=>SQL Server Management Studio Express=>Right clicked on Databases=> clicked on "Attach..."=> "Attach Databese" showed up. But I can not type in anything under the MDF File Location, Database Name, Attach As, Owner, Status, Message!!!??? What is wrong in my way of doing the attachment of AdventureWorks database (described above)? Please help and advise.
Thanks,
Scott Chang
P. S. I do not have Microsoft Visual Studio 2005. Walkthrough: Install the AdventureWorks Database (http://msdn2.microsoft/en-us/library/ms31035.aspx) : To confirm your SQL Server data directory (Start=>All Programs, Microsoft Visual Studio 2005, Visual Studio Tools, Visual Studio 2005 Command Prompt) steps 1 thru 4 can not be applied to my SQL Server Management Studio Express. I read an SQL Express post dated 19 April 2006 and learned the above-mentioned way to attach the AdventureWorks database in the SQL Server Management Studio Express. But that way does not work for me.
AdventureWorks In Management Studio Is Gone: How To Reinstall Its Database && Data Warehouse From Script Or By Downloading
Oct 28, 2007Hi all,
One year ago, I did "Ruuning Setup to Install AdventureWorks Sample Databases and Sample" to install "AdventureWorks" in my SQL Server Management Studio Express. Now, It just have the name "AdventureWorks" on and no contents (no tables, schemas, etc.) in it. In my Control Panel, Add or Remove Programs, AdventureWorksDB (162.00 MB) is still there and AdventureWorks (Windows Installer Package [27,992 KB]) is in my C:/drive.
(1) Should I delete the name "AdventureWorks" in my SQL Server Management Studio Express, and remove AdventureWorksDB (162.00 MB) from the Add or Remove Program, before I re-install AdventureWorks, AdventureWorksDW, and Adventure Works DW sample databases and samples from Windows Installer Package [27,992 KB]? Is my old AdventureWorks (Windows Installer Package [27,992 KB]) still good and complete for installation?
(2) SQL Server 2005 Books Online (September 2007) presents "Reinstalling Sample Databases from Script". But (i) I can not find the file instawdb.sql for reinstalling AdventureWorks from script and I do not have AdventureWorks OLTP in my C:Program FilesMicrosoft SQL Server90ToolsSamples folder, (ii) I can not find the file instawdwdb.sql for reinstalling AdventureWorksDW from script and I do not have AdventureWorks Data Warehouse in my C:Program FilesMicrosoft SQL Server90ToolsSamples folder either!!??
Please help and tell me what is the best way and some detailed instructions/tips to have AdvenureWorks, AdventureWorksDW, and Adventure Works DW sample databases and samples installed in my SQL Server Management Studio Express.
Thanks in advance,
Scott Chang
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 RelatedThe AdventureWorks DB Design
Dec 20, 2005Is it a good template for, say, limited CRM applications ?
View 1 Replies View RelatedNeed 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