|  |
RickN
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
 max databases
I'm setting up a .Net remoting application to be accessed via the web. Each
customer will need there own unique database for security and other reasons.
I'm thinking the best way to do this is to assign each there own connection
string passed into the application. Is this the best way to address this
need and if so, under SQL 2000 is there a maximum number of databases that
can be set up?
Thanks,
RickN
Report this post to a moderator
|
|
 11-15-02 02:23 PM
|
|
Dejan Sarka
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
|
Re: max databases
> I'm thinking the best way to do this is to assign each there own
connection
> string passed into the application. Is this the best way to address this
> need and if so, under SQL 2000 is there a maximum number of databases that
> can be set up?
Yes, 32.767.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
Report this post to a moderator
|
|
|
11-15-02 02:23 PM
|
|
Hal Berenson
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
|
Re: max databases
That's the theoretical maximum. From a practical standpoint each instance
is limited to a few hundred, and you need to turn on auto-close to make that
practical.
--
Hal Berenson
True Mountain Consulting
"Dejan Sarka" < dejan_please_reply_to_newsgrou
ps.sarka@reproms.si> wrote in
message news:#uFrhDLjCHA.1652@tkmsftngp11...
> > I'm thinking the best way to do this is to assign each there own
> connection
> > string passed into the application. Is this the best way to address
this
> > need and if so, under SQL 2000 is there a maximum number of databases
that
> > can be set up?
>
> Yes, 32.767.
>
> --
> Dejan Sarka, SQL Server MVP
> FAQ from Neil & others at: http://www.sqlserverfaq.com
> Please reply only to the newsgroups.
> PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>
Report this post to a moderator
|
|
|
11-15-02 06:23 PM
|
|
Dejan Sarka
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
|
Re: max databases
Actually, I would say that after few hundreds, auto-close on or off, we are
in not very practical state...
--
Dejan Sarka
"Hal Berenson" < haroldb@truemountainconsulting
.com> wrote in message
news:OXCniuMjCHA.2672@tkmsftngp11...
> That's the theoretical maximum. From a practical standpoint each instance
> is limited to a few hundred, and you need to turn on auto-close to make
that
> practical.
>
> --
> Hal Berenson
> True Mountain Consulting
>
>
> "Dejan Sarka" < dejan_please_reply_to_newsgrou
ps.sarka@reproms.si> wrote in
> message news:#uFrhDLjCHA.1652@tkmsftngp11...
> > > I'm thinking the best way to do this is to assign each there own
> > connection
> > > string passed into the application. Is this the best way to address
> this
> > > need and if so, under SQL 2000 is there a maximum number of databases
> that
> > > can be set up?
> >
> > Yes, 32.767.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > FAQ from Neil & others at: http://www.sqlserverfaq.com
> > Please reply only to the newsgroups.
> > PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> >
> >
>
>
Report this post to a moderator
|
|
|
11-15-02 08:23 PM
|
|
|
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is OFF. |
|
ExamNotes forum archive
|
