How to setup a database on SQL server provided?
479077
CREATE DATABASE [Database Name];\n\nWithout knowing the scope of your question, that is all there is to it.
937744
If what you are asking is what you can use to store and manage data (don't know about the 'buy' part) I can take a stab at it. \n\nI am a software engineer that has been writing database applications for 13 years. What I have used are:\nMicrosoft Access (http://office.microsoft.com/en-us/access/default.aspx)\nMySQL (an Open Source, free database) (http://www.mysql.com/)\nMicrosoft SQL Server (http://www.microsoft.com/sql/default.mspx) and \nOracle (http://www.oracle.com/index.html).  \n\nThese are pretty much the viable solutions depending on the application. MS Access is more of a poor-mans solution but certainly capable of handling 100's of thousands of rows of data, MySQL is a bit more complex but has evolved and even has a User Interface to manage the database now and fairly capable in terms of it's data capacity. SQL Server/Oracle are the full-blown Database Management Systems (DBMS) that cost the big bucks to license but are what large enterprises/web sites use to hold all their data.\n\nHope this helps.
1167306
The short answer is that you have to have an external (remote) database setup, then you can use odbc to connect to it.
1032537
Learn to use Microsoft Access and build it yourself.  You're not likely to get someone to write you a database for free.\n\nAccess has pre-built databases and wizards that spoon feed you through development.  Try it, you may enjoy it.
210492
In SQL Server Express, which is probably what you downloaded, the server is going to be {COMPUTERNAME}&#92;SQLEXPRESS, where {COMPUTERNAME} is the machine name of your computer.\n\nFor example, my computer is named BARDOLF, so my SqlExpress server is named BARDOLF&#92;SQLEXPRESS\n\nYou might find the Microsoft SQL Server Management Studio Express CTP to be useful in connecting to, and managing, SQL Server Express.\n\nYou can download it directly from Microsoft. It works just like Enterprise Manager does in full SQL Server.\n\nADDENDUM:\n\nEnsure you're running the SQL Server Express service.\n\nStart --> Control Panel --> Administrative Tools --> Services\n\nMake sure you see:\nSql Server (SQLEXPRESS)\nSql Server Active Directory Helper\nSql Server Browser\nSql Server VSS Writer\n\nMake sure they all state "Started". If any do not:\n\n1. Right-click on the item and choose Properties\n2. Under the general tab, select Automatic from the Startup Type menu\n3. Click OK\n\nRepeat for all items.\n\nRestart the computer.\n\nLaunch the management console following restart and try to connect.\n\nUpdate question again if that doesn't work. I've added this to my watch list.
96164
I suggest you use a DTS package, making a DTS (Data Transfermation Package), a function of the SQL Server, will\ngreatly simplify the task of getting data from Excel to SQL server. they can be saved and setup to run on a schedule or just used once. Great feature :)
227104
Microsoft Access might be a nice choice to start.  If you decide to go to something else, the database file itself can be easily converted to another database program, and it is compatible with SQL and ODBC
1035740
If your trying to learn how to set up and administrate databases the best reference I have found is link below:\nhttp://www.microsoft.com/technet/prodtechnol/sql/2000/books/pkadmindefault.mspx\n\nIf your trying to learn how to connect VB to MS SQL Server datasets then you should refer to the MSDN site for examples.  This site has reference links to VB and MS SQL\nhttp://www.microsoft.com/msdn\n\nGood luck
48415
You would need Apache server http://httpd.apache.org/, you might also want to install MySQL http://www.mysql.com/ or PostgreSQL http://www.postgresql.org/ for database management.  In addition you might also want to install PHP www.php.net to run PHP scripts. With those 3 things you should be able to start a simple web server.
781920
you can pick up a dummies book for the sql.\n\nsee the dummies website listed below.  several books and articles for you to begin with.
108436
As m1rr0r explained it all depends on the server you are using.  The process would be something like this:\nExport Database and save it locally.  Import database in to local server. Repoint software to locally instead of remote location.\n\nIf your using MYSQl then you can use PhpAdmin To export the database.\n\nPlease put more details if you can.
888756
You can use a freeware version of SQLyog tool from http://www.webyog.com/.\n\n1. You have to first register both you production server and the development server.\n\n2. Make a connection to both servers\n\n3. Create a blank database on prodction server (in case there is no database on production server).\n\n3. Right click on the production server database and select the 'Copy databases to different Host/DB...'
346060
just try going to this link\n\nhttp://www.w3schools.com/sql/sql_intro.asp\n\nmight help
815265
The PostgreSQL database server provides a reliable, robust database solution at no cost. Here's a link which will clearly expalins how to do it\n\nhttp://www.builderau.com.au/program/dotnet/soa/Integrate_PostgreSQL_with_NET/0,339028399,339267580,00.htm
1151470
You would have to use a programming language to open the database and access the data enclosed.  Typical languages include ASP, PHP and java.  It depends on what operating system your web server is running and how familiar you are with programming.
281205
My experience with MySQL / Sybase / SQL Server when you DON'T have an ODBC complient data source is the create (in the native language of the source information) an output file of SQL insert statements.\n\nFor example, if the data source is three fields (F1, F2, and F3) that have the values 1, "a", and 3 in the first record, I'd create a program that reads from the source and outputs into a text file....\n\nINSERT INTO newfile (F1, F2, F3) VALUES (1, 'a', 3) GO\nINSERT INTO newfile (F1, F2, F3) VALUES (....\n\nThen, I'd just use the batch function of the SQL database to execute that text file as a SQL script.
850443
ok I give some hints\nIf you want to refer to a database from Excel you need to add the ADO 2.8 objects Library. \nHow to proceed?\nFrom the Visual basic editor, click on tools (menu bar) and then reference. look for Microsoft Activex Data objects 2.8 library and tick it.\nNow you should have access to ADO objects.\nTo learn how to use these objects try the msdn microsoft website, full of advice and templates\n\nIf you want an example from me, give me a valid email address where i can send you an excel workbook and small access data base for it takes too long to explain