|
Home > Archive > MS SQL Server > September 2005 > Instances with different server settings
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
| |
| Jerry Spivey 2005-09-28, 8:23 pm |
| 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...
>
>
>
|
|
|
|
|