using SQL Server for multiple apps

[chelms]

Is it possible to add databases to an existing SQL Server and keep those databases completely separate from anything that's already setup within SQL Server to run mulitple apps? I would like to run an app from SQL Server that I already have but keep everything I setup for that app but make sure that it doesn't affect anything that's there already. I don't want to have to buy another install of SQL server also.

Any suggestions?

Thanks,
Charles H.

 

[Ruairi]

One SQL Server installation can manage many databases. I am currently developing an app that uses SQL Server. For testing purposes i have 2 copies of the same database running on one Server. I can acces either DB by simply changing the database name in the connection string. You don't have to do anything special to use multiple DBs from one server, just create the new database. Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontroltechnologies.com

 

[foxdev]

There are some things that are shared between databases, but nothing that would be apparent to the applications - these include the tempdb database and the server logins (but not database users). For all practical purposes, one application would not know about other databases on the server unless you gave that application/user permissions to do so.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org