 | View Full Version : sql7 cptkoi 10-22-2001, 03:46 PM I have shared sql space on a server which i want to share... That is i have one account with 500MB of space and associated log space, is it possible to run more than one database from within this space? If so how? Thanks in advance :D ffeingol 10-22-2001, 04:19 PM When you say "SQL7", is that a Microsoft SQL Server 7? If so, do you have create database permissions? If so, you can create multiple databases. Frank cptkoi 10-22-2001, 05:15 PM Yeah microsoft sql 7 and no i dont have acess to create a new database, i have been told its possible to share the space but i am unsure as to how? :cartman: ffeingol 10-22-2001, 05:24 PM Well it should be possible, but more complicated. Each "applicaiton" would have to give it's tables a prefix or suffix to insure that they are unique withing the db. You better really trust the people you are sharing with. Since you are all in the same db (with only 1 user-id/password I assume) anyone can totally distroy each others data. Does this make sense? Frank cptkoi 10-22-2001, 05:30 PM A friend builds them (databases) that is and he built the exisitng one for me, it takes up hardly any space and i got a guy who wants me to build a site and wack an sql dbase on it for him, rather than shell out for more space y not share...... mattan 10-23-2001, 05:20 AM Most SQL host go by diskspace and database (which is normally one) But like what has been mentioned above, if you manually rename or at the very least ensure that each of your tables are name differently then you could in theory run "many small database" in your account. But for manageability its better to start off each table for a particular database with its own prefix like db1_xxxx, etc cheers! cptkoi 10-23-2001, 05:23 AM Thanks for the help guys much appreciated :) |