maximum number of views

What is the maximum number of views that you can create
for a SQL Server 2000 database?
Only limited by the maximum number of objects you can create in a =
database - which is huge (documented in BOL) under "maximum capacity =
specifications". If i remember right it is about 2 billion in theory =
but something else will get you first, so for sake of argument I would =
sy there is no practical limit.
I'm interested why this would be an issue?
Mike John
"Derek Ruesch" <anonymous@.discussions.microsoft.com> wrote in message =
news:31c901c470fa$1c952d90$a301280a@.phx.gbl...
> What is the maximum number of views that you can create=20
> for a SQL Server 2000 database?
|||Mike,
I have 31 views currently in my database and I plan on
adding another 20 views or so. I just wanted to make sure
that I could have this many views.
Derek

>--Original Message--
>Only limited by the maximum number of objects you can
create in a database - which is huge (documented in BOL)
under "maximum capacity specifications". If i remember
right it is about 2 billion in theory but something else
will get you first, so for sake of argument I would sy
there is no practical limit.
>I'm interested why this would be an issue?
>Mike John
>"Derek Ruesch" <anonymous@.discussions.microsoft.com>
wrote in message news:31c901c470fa$1c952d90
$a301280a@.phx.gbl...
>.
>
|||No problem whatsoever from a system limit point of view. I was a bit =
concerned you planned on creating the odd 10000 or so, which would have =
impled a very odd design!
Mike John
"Derek Ruesch" <anonymous@.discussions.microsoft.com> wrote in message =
news:321101c47101$615f7b90$a301280a@.phx.gbl...[vbcol=seagreen]
> Mike,
>=20
> I have 31 views currently in my database and I plan on=20
> adding another 20 views or so. I just wanted to make sure=20
> that I could have this many views.
>=20
> Derek
>=20
> create in a database - which is huge (documented in BOL)=20
> under "maximum capacity specifications". If i remember=20
> right it is about 2 billion in theory but something else=20
> will get you first, so for sake of argument I would sy=20
> there is no practical limit.
> wrote in message news:31c901c470fa$1c952d90
> $a301280a@.phx.gbl...