Named Instances

Is there any limit for installing named instances on a server?
Hi
Yes, maximum supported on SQL Server 2000 is 16.
If you have per server licensing, you need a licence for each instance (per
processor licence covers all instances).
Memory. They all need to share the same RAM. If you have 16 instances, with
each needing 1Gb, you need at least 16Gb of RAM on the box.
Regards
Mike
"SB138" wrote:

> Is there any limit for installing named instances on a server?
|||Thanks
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Yes, maximum supported on SQL Server 2000 is 16.
> If you have per server licensing, you need a licence for each instance (per
> processor licence covers all instances).
> Memory. They all need to share the same RAM. If you have 16 instances, with
> each needing 1Gb, you need at least 16Gb of RAM on the box.
> Regards
> Mike
> "SB138" wrote: