how many tables you can create in sql server database?
812928
There's no (practical) limit.  Most likely, you'll run out of space before it becomes an issue.
450877
I don't see the problem.  If you can replicate one database, you should be able to replicate multiple databases.  Maybe at quick look at this will help:\n\nhttp://dev.mysql.com/doc/refman/4.1/en/replication.html\n\n...or this one:\n\nhttp://www.oreilly.com/catalog/hpmysql/chapter/ch07.pdf
1047491
Use the IDENTITY property.\n\nfor example:\n\ncreate table employees\n(\nemp_id smallint identity(101,1) not null\nempname varchar(50) not null\n)\nGO\n\ncreates a 2 column table with an incrementing field called emp_id.  the numbering sequence starts at 101, and is incremented in units of 1
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
139090
If you refer to databases, no, it's not possible.\nA table can have a single primary key, which are used to uniquely identify a record. Aside from that a table may have a number of keys and foreign keys.
950543
there are lot of tools u can use to createa database it depends on the purpose as to why u want to create and what are u looking to do after that etcc....
424880
You can split the database: tables in a computer, queries, forms, reports and macros in another. For instance, you can have a 3 computer lan where:\n\ncomputer1 has the tables\ncomputer2 has some queries, forms, reports and macros\ncomputer3 has different queries, forms, reports and macros.\n\nThe way computer2 sees the database may be different from the way computer3 sees it.\n\nYou split a database going to menu Tools>Database Utilities>Database Splitter
435503
First of all what specifically do you want to know?\n\nRDBMS or Relational Database management systems work by using relations to link tables to eachother. you can have multiple table that hold various kinds of data and have it all be mapped to one or many keys. You essentially are able to create one to one or one to many relations between your tables using RDBMS
1080020
Can you install a seperate named instance?  You should be able to run multiple servers under different named instances.  Uninstallations that dont complete are usually pretty hairy but this feature of Sql 2k5 should at least give you some workaround.
144872
Create a new database, using the Database Wizard.  There, it will give you different samples.  There is probably several ready-to-run examples there to use...
1095851
I certainly would not use multiple table for something that simple. It is like going around the world to get back to your elbow.\n\nFurthermore, I think that it is a one to many relationship...one applicant to many jobs or one applicant to many schools.\n\nIt can all be done in a single table and use a long text field as the experience and use a long text field as the education.\n\nYou can use a delimited field broken down between one job and the next or between one school and the next.\n\nDoing a search, you can search for any schools (a string) with in a text field.\n\nThe answer would not just apply to Access, but any database application.
479077
CREATE DATABASE [Database Name];\n\nWithout knowing the scope of your question, that is all there is to it.
1131802
In case you wanted to run more than one database for your site.\n\nEg. a database of customers/clients, and a database of your products/services, and still another for your staff to log-in, and yet another for your suppliers...
641087
Use Select Into option to migrate the data. You will need one select into statement for each of the tables.\n\nSELECT * INTO db1.dbo.table_name FROM db2.dbo.table_name\n\nHere dbo refers to database owner and db1 & db2 are the databases.
923590
If it's a standard .sql file, you should be able to split it. This would break transactions, but depending on the statements in the file this may not be an issue.
126717
Access has limits in it's database it's not ment to be a bussiness database thats what sql is for...\nhttp://databases.about.com/cs/tutorials/a/widgetmenu.htm
14804
HI There, pretty much like it was on version5 - create the connection first, and create your tables and join them..i suggest going on a course couple be an idea because it is actually a bit complex . Check on www.forumtopics.com/bobj\ncheers\ntake care