Vineet, > -Does data get stored by running the "setup" procedure??
Yes, The data is inserted when you run the SetupActions. In particularly, The SetupActions creates storeprocedures to insert the data from the XML documents stored in setup_utilities\DataLoad\StockTraderDB > -How can i find the data of individual accounts?? The data for an individual account is stored in the ORDERS and HOLDINGS tables In SQL Management Studio you can: 1. expand the StockTraderDB Database 2. expand the Tables category 3. Right-Click the Table named Orders and click Edit Top 200 Or 1. Right Click the StockTraderDB and choose New Query 2. Copy the following in there and change SET @accountId to the number your looking for 3. Click Execute -- Begin SQL Query DECLARE @accountID int SET @accountID = 1 SELECT * FROM ORDERS WHERE ACCOUNT_ACCOUNTID = @accountId SELECT * FROM HOLDING WHERE ACCOUNT_ACCOUNTID = @accountId -- End SQL Query -----Original Message----- From: Vineet ghatge [mailto:[email protected]] Sent: Monday, April 27, 2009 11:00 AM To: [email protected] Subject: Re: DATABASE HELP On Sun, Apr 26, 2009 at 7:01 PM, Ben Dewey <[email protected]> wrote: > Vineet, > > It sounds like you should be okay. There was also a patch to the > SetupActions/Program.cs file that displays a message saying "Press any key > to continue.". > > When it says you are unable to open the files, are you trying to double > click? If so that's not going to work. The MDF file is the actual database > and when the SetupAction scripts runs it attaches the database to SQLServer, > thus using it by another process. In order to view that newly created > database, Open SQL Management Studio, connect to .\MSSQLServer, and expand > Databases, you should see a StockTraderDB on that list. > > -Ben > > Hi Ben, > Thanks for those instructions .I followed your instructions and found StockTraderDB on the list of"database".Can please tell me:- -Does data get stored by running the "setup" procedure?? -How can i find the data of individual accounts?? With Regards, Vineet ghatge H > > ________________________________________ > From: Vineet ghatge [[email protected]] > Sent: Saturday, April 25, 2009 11:37 PM > To: [email protected] > Subject: DATABASE HELP > > Hello all, > > I have managed to create "SetupActions.exe" according to steps described by > Scott Golightly on Apr 6(Subject:How to create and populate DB) > After running the "SetupAction.exe" in the command prompt(as an > administrator) i got the following as the output:- > > -Setting up database > -Config.Appsettings: > -dbserver is .\MSSQLExpress > -installPath is C:\StockTraderDemo\ > dbadmin is sa > authType is SQL > .......................................(cursor stops here) > Does this mean it that it finished populating database? How do I knw that I > finished populating the database???. > > While the command prompt runs at following path C:\Program Files\Microsoft > SQL Server\MSSQL.1\MSSQL\Data,it creates two files:- > 1)StockTraderDB.mdf----SQL Server Database Primary Data File > 2)StockTraderDB_log.LDF---SQL Server Database Transaction Log File > > But I am unable to open the file instead throws an error saying "its being > used by another process". I did not understand why?? . > > I am running the whole process on Windows XP OS > > With Regards, > Vineet Ghatge H >
