What can be done if the shared web hoster I am using allows only 1 sql
server database and a second web application I would like to install is
configured to use its own database?

can databases be nested, one within another?

thanks,

-Steve

You can implement 2 or more distinct schemas in one database by using
different name spaces (object owners). Using permissions, you can make each
schema invisible to other applications to prevent accidental overlap.

On 24 Apr 2005 17:39:51 -0700, "Steve Richter" <StephenRichter (AT) gmail (DOT) com>
wrote:

The separate schema approach suggested by Steve is a good one but a caveat
is that you'll need different logins in order to implement that solution.
If your provider limits you to a single login, you can still deploy as many
apps as you like in a single database using the 'dbo' schema as long as you
have no object name conflicts. You can adopt an object naming convention to
make it easier to identify the associated application.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Steve Richter" <StephenRichter (AT) gmail (DOT) com> wrote

thanks Dan and Steve. Your answers helped me a lot!

-Steve

Dan Guzman wrote:

Steve Richter wrote:

Why don't you just pay for their service instead of trying to circumvent it.