"Fred Payne" <fpayne@ryerson.ca> wrote in message news:<bnohcm$u46$1@news.ryerson.ca>...
> Hello All,
> I'm using SQL Server 2000 and wish to restrict the user login to one
> instance only. Is this possible? Is this wise?

Assuming that you mean 'instance' as in 'named instance' (see Books
Online), then each instance is a separate installation, so you manage
security separately for each one. If a user doesn't need access to one
of the instances, then you simply don't grant access to that one. If
this doesn't help, perhaps you could clarify exactly what you want to
achieve?

Simon