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 > 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...
>> What is the maximum number of views that you can create
>> for a SQL Server 2000 database?
>.
>|||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...
> 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...
> >> What is the maximum number of views that you can create > >> for a SQL Server 2000 database?
> >.
> >