I need a database file for a bank with info like customers, transactions and other bank stuff etc. It is for a university assignment. basically I just need to analyse, mine the data etc the info in the database
I have looked on msdn but none of they're databases are for a banking scenario.
Does anyone know of a sample bank database anywhere or does someone have one they could give to me ?
I'm currently building a database that is going to have at least 6 different types of users accessing it via a web application.
A user will have different information collected about them. A few of of the users will have the same or similiar information collected about them.
I will be using role based authentication.
Now my query is this;
Scenario 1: Would it be a good idea to keep all the users common information in one table. Ie. thier username,email,password,name. Then create a tblDetails for each type of user that would contain the different data. That way i can just check one table to verify thier login credentials.
OR Scenario 2: Would it be best to create a seperate table for each type of user and then log them in based on the credentials stored in each type of users respective table.
Hope this is clear. I'm leaning towards scenario 1, although I've used scenario 2 before. Just wondering which would be preferred.
Books online mention the existence of sample code for several custom tasks, including the one mentioned in the title. But, when I try to find this code in the location mentioned it is nowhere to be found.
I have run a search on the rest of my drive and come up empty.
Im trying to use VB.net 2005 to write a sample app to access a DB. Are there any samples for this and any samples of how I go about making the DB in the first place?
I'm looking for a sample database for a big company, organization,... to build my db project as a part of my db system courses. Can anybody help me? Thanks anyway.
i have a query that uses the adventure works sample database am working on sql server 2000 can i install this sample database to this sql2000 server? Best Regards
Hi im a beginner in SQL. I installed SQL Server Express on my computer, but i didnt find any databases included. The institute where i go to learn SQL have plenty of databases, but students usually work on databases called AdventureWorks and GlobalToyz. I searched the web for these databases and found something but i still cant figure out what to do with it. So i was hoping if anybody could send me these databases with brief instructions on how to install it into SQL Server. Thanks in advance
I had installed the sample database " AdventureWorks ",but i couldn't find it in SQL Server Management Studio,and I noticed than it was installed into "Microsoft SQL Server 2005 Samples" directory,but not "Microsoft SQL Server" directory,what can I do to find the datebase. I am a beginner,and learning sqlserver by using tutorials,someone help me? many many thanks.
I install the SQL 2005 Evaluation. I selected to install samples and documentation during the installation wizard. It finished successfully but I could not find the sample databases on the SQL Management Studio. Why?
This question is for SQL Server 2000, SQL Server 2005, and SQL Server 2008.
I want to provide users a sample database with data and a database template which new databases created in an application will be based on. However, I don't want to use scripts to create database and other database objects and also don't want the data to be contained in other data store such as access database. I think about providing users with operating system files(mdf, ndf, log). My understanding is that database created thru attaching will follow the collation of the source. Is that a way to control the attaching so the database created thru attaching will follow the collation of the destination server?
If attaching is not a good way to handle my case, what are other possibilities?
hi, i learn by practice and i would like an asp code using c# that connects to sql database can retrives information from a table. can you please copy paste me some code or give me exact link a?
to download AdventureWorksDB.msi. Once I save that to my local machine I run the install and it completes with no errors. Unfortunately, I can't see any of the data in SQL Server Management Studio Express. I'm new to SQL Server Express so maybe its me, but I get the feeling that it was never added to the database. I'm still looking for SQLServerExpressSamplesOverview.htm to see if I am missing a step but I can't find it anywhere.
The install seems to have extracted database files but if I need to run some scripts by hand to create the database I don't know which order to run them in.
Hello, I am very new to SQL Server. I have downloaded the SQL Server 2005 Express from microsoft's website and installed it on Windows Vista. I have also downlaoded the sample databases like pubs, northwind from http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en and adventure works from the respective site. When i try to run the script of pubs and northwind, it generates error messages and it is as follows: Msg 911, Level 16, State 1, Line 2 Could not locate entry in sysdatabases for database 'pubs'. No entry found with that name. Make sure that the name is entered correctly. Msg 262, Level 14, State 4, Procedure sp_dboption, Line 0 SHOWPLAN permission denied in database 'master'. Msg 262, Level 14, State 4, Procedure sp_addtype, Line 0 SHOWPLAN permission denied in database 'master'. Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #1: Cannot find data type id. Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #1: Cannot find data type tid. Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #1: Cannot find data type id. Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #6: Cannot find data type tid. Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #1: Cannot find data type tid. Msg 2715, Level 16, State 7, Line 2 Column, parameter, or variable #1: Cannot find data type empid. Msg 8197, Level 16, State 4, Procedure employee_insupd, Line 2 The object 'employee' does not exist or is invalid for this operation. Msg 208, Level 16, State 1, Line 2 Invalid object name 'authors'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'publishers'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'pub_info'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'titles'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'titleauthor'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'stores'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'sales'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'roysched'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'roysched'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'roysched'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'roysched'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'roysched'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'roysched'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'roysched'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'roysched'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'roysched'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'discounts'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'jobs'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'employee'. Msg 208, Level 16, State 1, Line 2 Invalid object name 'employee'. Msg 208, Level 16, State 1, Procedure titleview, Line 4 Invalid object name 'authors'.
I think thess errors are mostly due to windows vista's new security features at the user level. However, I using my home computer and the admin privileges and in this case I shouldn't have any problem running it unless there's anything to be done on vista to work this. I'll appreciate if anyone helps me installing the sample files. Thanks in advance.
Regarding the code/db from the REAL project that just got released, I have no problem attaching the "REAL Sample V6" database, but the "REAL Warehouse Sample V6" database requires ENTERPRISE edition, because the default copy uses Partitioning (i.e. the PT version, although the document stated that the multi-table (MT) version is the default). I only have the STANDARD edition of SQL 2005, is there a workaround?
Need help.After I installed MSDE. I opened a command prompt and navigate to C:Program FilesMicrosoft Visual studio .NET 2003SDKv1.1SamplesSetupAnd then I typed in: oSpl -S(local)VSdotNET -E -i instpubs.sqlI got the message:[DBNETLIB]SQL Server does not exist or acdcess denied.[DENETLIB]ConnectionOpen (Connect()).How can I fix it?The server 2000 is running and it's mixed login authentication.OS: windows server 2003Thank you,William
The sample application provided with Access Database Synchronizer fires a "A request to send data to the computer running IIS has failed. For more information, see HRESULT." exception on my WinCE 4.2 device.
I debugged it with VS2005 to see what was going on and found that the problem resides in the line:
m_connDesktop.Pull("MSysObjects","SELECT Name FROM MSysObjects WHERE Type=1 and flags=0",accessSysConnectString,RDATrackOption.TrackingOff,"Err_MSysObjects");
It seems that connection m_connDesktop is ok but calling Pull method fails.
I've verified that SSEvAccessSync service is started when ActiveSync detects device connection and that firewall rules are correctly updated.
Also, i verified my System.mdw and i discovered that there is no "MSysObjects" table (only MSysGroupList, MSysGroupMembers, MSysUserList and MSysUserMemberships queries are there).
Do you think the problem is there?
How can i solve it without damaging System.mdw?
I cannot figure out what's the purpose of this line of code, can you help me?
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 ?
I am working through the book ASP.Net Unleashed Second Addition. I am trying to open a simple database connection. (using the sample "pubs" db from SQL Server)I have copied the author's code exactly, but it just won't work. I keep getting this error:What am I doing wrong?????Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30182: Type expected.Source Error:
Line 5: Line 6: Sub Page_Load Line 7: Dim conPubs As SqlConnection Line 8: conPubs = New SqlConnection( "server=localhost;uid=webuser;pwd=secret;database=pubs" ) Line 9: conPubs.Open()
I downloaded the SR2 - major mistake Now I cannot get into the sample databases I have on my machine. I can attach to the Servers, but they have SR1 and now I guess if I would make changes from my SR2, then they will be screwed up.
My error when I try to log into my machine (adventure works) is:
TITLE: Connect to Server ------------------------------
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
------------------------------ BUTTONS:
OK ------------------------------
Is there any way to reverse SR2? Should I reinstall SQL 2005?
Hi all, Can anyone give me a ready-made sample script to display a search reslut from a database? My intention is to give a dynamic web page for the search in the BookStore website. The result will show the following:- First the picture of the book. To the right of it, 'Title' field, below that, 'description' field It should be created programatically as the contents are in the database. I tried several ways, but could not succeed. I have the BookID, Title, BookPicture, and the Description fields Thanking you in advance, Tomy
I got 2 webservers (2003) using NLB. I want some kind of common data store (SQL Server). I need this data store to be fault tolerant. I don't have any more machines. I don't have an enterprise licence for windows.
I have a company with 5 offices connected with a dedicated line (500+ employees).
They have five databases, one in each office.
Now they want a new application which will replace the old (VB6 on MySQL will now be VB.NET 2.0 with MS SQL Server 2005).
The want all the data availiable in all the offices. We will still have 5 databases in 5 offices, but all with the same data.
Sometimes the dedicated line is lost.
Now I have a few questions:
Will the database be still running while a line is down? Will the database be still running if replication is of type Merge (instead of continuesly). Is it good practice to use unique identifiers versus Numeric keys? Is it good practice when the application uses the "master" database to save global things like "Suppliers" and the local database to add and change Orders? Do you have some recommended reads?
For High Protection mode (2servers, no witness, FULL safety), in the event of a catastrophic failure of the principal, can a remote (but well connected) mirror be forced to assume the principal role? The MS manual "Database Mirroring in SQL Server 2005" on p2 says the failover type for HP mode is manual only (as opposed to forced). Elsewhere it seems to seems suggest otherwise but there is no clear and unambiguous discussion describing the exact procedure.
I currently have a workflow "like" application which uses msmq to pass messages to each step transactionally. I'd like to take advantage to something like SSB to make the app scale. Here's how it works today:
Start Workflow WebService puts message on queue. Windows Service has threaded listeners on each queue for the workflow. The listeners do a transactional Receive off the queue. By doing this is in a transaction, we can enforce that only one listener will pick up and process the message. Once they have a message they call a .Net Assembly to perform some work. Once the work is performed succesfully, the listeners put the work context on the next queue using the same transaction as the receive and commit the transaction effectively removing the message from the receive queue permanently. If a fatal error occured during processing, the work context is moved to an error queue transactionaly. If the process blew up due to other reasons, the transaction is rolled back and the message reappears on the original queue so that another instance of the service can pick it up. Currently all this is running on one instance of the Windows service and cannot span more than one host machine since MSMQ did not support transactional reads off public queues without using DTC.
I saw the external activator sample and it looks great but I have a few questions. First, I'd have to modify it to call assemblies instead of external processes. No biggie there. One other requirement that one and only one receiver should process the message and that when the next message is sent to the next queue, it's done within the same transaction as the receive. I hope that this can be done without any deadlocks. I also saw mentioned somewhere that this messaging could advantage of the local SQLExpress instances so that even if the main SQL Server instance is down, the messages can go out. Last requirement is that our message is a blob (serialized .Net object) so how do we define that kind of message?
Table1: WriterID, WriterName, WriterSurname Table2: BookID, WriterID, BookName, Category Table3: CategoryID, CategoryName There will be one form. Which way i should use to enter data from one form to multiple tables with same WriterID. 1.) Should i use SqlCommand class and a Stored Procedure? ( Like that: http://www.aspnet101.com/aspnet101/tutorials.aspx?id=13 ) 2.) Is there another way without a stored procedure? I can't imagine how to insert same form to multiple tables. In real scenario there are lots of table and all contains a column that holds same value such as WriterID.
Hi, I want to know the a solution for my Synchronization Scenario
I have a several client databses which are SQL Server 2005 Express and i have a master database which is SQL Server 2000 containing all the individual Client databases. All the individual client databases are kept seperately at the master location. I need to Synchronization the client database with its copy at the master database (something like Merge replication). Both the Client Copy as well as Master Copy could be Publishers & Subscribers.
Now the problem is Because of security & firewall issues, only the Client should have the ability to schedule & initiate the synchronization process with the master copy. Unfortunately SQL Server 2005 Express has only subscriber agent and not a publisher agent.
Any help on how to achieve this would be appreciated . Thank You
Hello All .. This is the scenario I'm having : -- I'm a beginner so bear the way I'm putting it ... sorry !
* I have a database with tables - company: CompanyID, CompanyName - Person: PersonID, PersonName, CompanyID (fk) - Supplier: SupplierID, SupplierCode, SupplierName, CompanyID (fk)
In the Stored Procedures associated (insertCompany, insertPerson, insertSupplier), I want to check the existance of SupplierID .. which should be the 'Output' ...
There could be different ways to do it like: 1) - In the supplier stored procedure I can read the ID (SELECT) and :
if it exists (I save the existing SupplierID - to 'return' it at the end). if it doesn't (I insert the Company, the Person and save the new SupplierID - to 'return' it at the end) ------------------------------------ 2) - Other way is by doing multiple stored procedures, . one SP that checks, . another SP that do inserts . and a main SP that calls the check SP and gets the values and base the results according to conditions (if - else)
3) it could be done (maybe) using Functions in SQL SERVER...
There should be some reasons why I need to go for one of the methods or another method ! I want to know the best practice for this scenario in terms of performance and other issues - consider a similar big scenario ..... !!!
I'll appreciate your help ... Thanks in Advance . ! .
How can I be able to use "NewReceivedTime" as a variable? Since having to create a new column using CASE statement in SQL would mean that user will not be able to use this new column name and having to receive error such as "Invalid Column Name: NewReceivedTime "
(case when <value> else <value> end) as NewReceivedTime
I'm asking this because, I would want to use "NewReceivedTime" I've created to equate to another Time Column like NewReceivedTime = LogDateTime something like that.
i hav a text file in this format.. currency,exchangerate(INR),date dollar,45,20/04/2006 dollar,46,22/04/2006 britishpound,65,20/04/06 dirham,12,20/04/06..etc..
now,i want that using this as source.. 2 tables should be created and filled with appropriate data.. CurrencyMaster..Currencyid(PK),Currencyname CurrencyDailyRate..ID,Currencyid(FK),rate,date
