Instances with different server settings

Hello,

Is it possible to have two instances of SQL Server 2000 and have each of
them a different configuration of server settings?
This is, I would like to have one instance (e.g. GeneralApps) with the
"nested triggers" disabled and another instance (e.g. SpecialApps) with the
nested triggers enabled.

Thanks in advance
Cesar

Cesar,

Sure.  Each instance of SQL Server has it's own set of system databases so
the configuration settings can be different.

HTH

Jerry
"Cesar" <Cesar@discussions.microsoft.com> wrote in message
news:43C1E2FB-95A7-4616-B9A7- 7B28E666BAFA@microso
ft.com...
> Hello,
>
> Is it possible to have two instances of SQL Server 2000 and have each of
> them a different configuration of server settings?
> This is, I would like to have one instance (e.g. GeneralApps) with the
> "nested triggers" disabled and another instance (e.g. SpecialApps) with
> the
> nested triggers enabled.
>
> Thanks in advance
> Cesar

Hello Jerry,

Thanks a lot !
Best regards,
Cesar

"Jerry Spivey" wrote:

> Cesar,
>
> Sure.  Each instance of SQL Server has it's own set of system databases so
> the configuration settings can be different.
>
> HTH
>
> Jerry
> "Cesar" <Cesar@discussions.microsoft.com> wrote in message
> news:43C1E2FB-95A7-4616-B9A7- 7B28E666BAFA@microso
ft.com... 
>
>
>