which file store startup parameters?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Niy

    which file store startup parameters?

    or in registry? where?
  • Douglas J. Steele

    #2
    Re: which file store startup parameters?

    What do you mean by startup parameters?

    --
    Doug Steele, Microsoft Access MVP

    (No private e-mails, please)



    "Niy" <niy38@hotmail. com> wrote in message
    news:55dd405a.0 404082058.e7268 50@posting.goog le.com...[color=blue]
    > or in registry? where?[/color]


    Comment

    • Dan Guzman

      #3
      Re: which file store startup parameters?

      Assuming you're referring to SQL Server startup parameters, these are
      accessible from Enterprise Manager under the general tab of server
      properties. These are stored in the registry.

      --
      Hope this helps.

      Dan Guzman
      SQL Server MVP

      "Niy" <niy38@hotmail. com> wrote in message
      news:55dd405a.0 404082058.e7268 50@posting.goog le.com...[color=blue]
      > or in registry? where?[/color]


      Comment

      • Niy

        #4
        Re: which file store startup parameters?

        yes, that's what I mean.

        If it's in registry, whereis are there?


        "Dan Guzman" <danguzman@nosp am-earthlink.net> wrote in message news:<NCJdc.394 3$A_4.1804@news read1.news.pas. earthlink.net>. ..[color=blue]
        > Assuming you're referring to SQL Server startup parameters, these are
        > accessible from Enterprise Manager under the general tab of server
        > properties. These are stored in the registry.
        >
        > --
        > Hope this helps.
        >
        > Dan Guzman
        > SQL Server MVP
        >
        > "Niy" <niy38@hotmail. com> wrote in message
        > news:55dd405a.0 404082058.e7268 50@posting.goog le.com...[color=green]
        > > or in registry? where?[/color][/color]

        Comment

        • Dan Guzman

          #5
          Re: which file store startup parameters?

          > If it's in registry, whereis are there?

          For a default SQL 2000 instance:

          HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\MSSQLSe rver\MSSQLServe r\Parameters

          For a named SQL 2000 instance:

          HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\Microso ft SQL
          Server\[InstanceName]\MSSQLServer\Pa rameters

          --
          Hope this helps.

          Dan Guzman
          SQL Server MVP

          "Niy" <niy38@hotmail. com> wrote in message
          news:55dd405a.0 404111911.7a31a f1f@posting.goo gle.com...[color=blue]
          > yes, that's what I mean.
          >
          > If it's in registry, whereis are there?
          >
          >
          > "Dan Guzman" <danguzman@nosp am-earthlink.net> wrote in message[/color]
          news:<NCJdc.394 3$A_4.1804@news read1.news.pas. earthlink.net>. ..[color=blue][color=green]
          > > Assuming you're referring to SQL Server startup parameters, these are
          > > accessible from Enterprise Manager under the general tab of server
          > > properties. These are stored in the registry.
          > >
          > > --
          > > Hope this helps.
          > >
          > > Dan Guzman
          > > SQL Server MVP
          > >
          > > "Niy" <niy38@hotmail. com> wrote in message
          > > news:55dd405a.0 404082058.e7268 50@posting.goog le.com...[color=darkred]
          > > > or in registry? where?[/color][/color][/color]


          Comment

          • Niy

            #6
            Re: which file store startup parameters?

            cool, thanks!

            BTW,can you recommend a good book or tutorial for learning MS SQL server?


            "Dan Guzman" <danguzman@nosp am-earthlink.net> wrote in message news:<yZnec.573 2$k05.1812@news read2.news.pas. earthlink.net>. ..[color=blue][color=green]
            > > If it's in registry, whereis are there?[/color]
            >
            > For a default SQL 2000 instance:
            >
            > HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\MSSQLSe rver\MSSQLServe r\Parameters
            >
            > For a named SQL 2000 instance:
            >
            > HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\Microso ft SQL
            > Server\[InstanceName]\MSSQLServer\Pa rameters
            >
            > --
            > Hope this helps.
            >
            > Dan Guzman
            > SQL Server MVP
            >
            > "Niy" <niy38@hotmail. com> wrote in message
            > news:55dd405a.0 404111911.7a31a f1f@posting.goo gle.com...[color=green]
            > > yes, that's what I mean.
            > >
            > > If it's in registry, whereis are there?
            > >
            > >
            > > "Dan Guzman" <danguzman@nosp am-earthlink.net> wrote in message[/color]
            > news:<NCJdc.394 3$A_4.1804@news read1.news.pas. earthlink.net>. ..[color=green][color=darkred]
            > > > Assuming you're referring to SQL Server startup parameters, these are
            > > > accessible from Enterprise Manager under the general tab of server
            > > > properties. These are stored in the registry.
            > > >
            > > > --
            > > > Hope this helps.
            > > >
            > > > Dan Guzman
            > > > SQL Server MVP
            > > >
            > > > "Niy" <niy38@hotmail. com> wrote in message
            > > > news:55dd405a.0 404082058.e7268 50@posting.goog le.com...
            > > > > or in registry? where?[/color][/color][/color]

            Comment

            • Niy

              #7
              Re: which file store startup parameters?

              cool, thanks!

              BTW,can you recommend a good book or tutorial for learning MS SQL server?


              "Dan Guzman" <danguzman@nosp am-earthlink.net> wrote in message news:<yZnec.573 2$k05.1812@news read2.news.pas. earthlink.net>. ..[color=blue][color=green]
              > > If it's in registry, whereis are there?[/color]
              >
              > For a default SQL 2000 instance:
              >
              > HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\MSSQLSe rver\MSSQLServe r\Parameters
              >
              > For a named SQL 2000 instance:
              >
              > HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\Microso ft SQL
              > Server\[InstanceName]\MSSQLServer\Pa rameters
              >
              > --
              > Hope this helps.
              >
              > Dan Guzman
              > SQL Server MVP
              >
              > "Niy" <niy38@hotmail. com> wrote in message
              > news:55dd405a.0 404111911.7a31a f1f@posting.goo gle.com...[color=green]
              > > yes, that's what I mean.
              > >
              > > If it's in registry, whereis are there?
              > >
              > >
              > > "Dan Guzman" <danguzman@nosp am-earthlink.net> wrote in message[/color]
              > news:<NCJdc.394 3$A_4.1804@news read1.news.pas. earthlink.net>. ..[color=green][color=darkred]
              > > > Assuming you're referring to SQL Server startup parameters, these are
              > > > accessible from Enterprise Manager under the general tab of server
              > > > properties. These are stored in the registry.
              > > >
              > > > --
              > > > Hope this helps.
              > > >
              > > > Dan Guzman
              > > > SQL Server MVP
              > > >
              > > > "Niy" <niy38@hotmail. com> wrote in message
              > > > news:55dd405a.0 404082058.e7268 50@posting.goog le.com...
              > > > > or in registry? where?[/color][/color][/color]

              Comment

              • Dan Guzman

                #8
                Re: which file store startup parameters?

                One of my favorites for SQL Server admin and internals is Inside SQL Server
                2000 <http://www.insidesqlse rver.com/index.html>.

                --
                Hope this helps.

                Dan Guzman
                SQL Server MVP

                "Niy" <niy38@hotmail. com> wrote in message
                news:55dd405a.0 404121931.da91b f3@posting.goog le.com...[color=blue]
                > cool, thanks!
                >
                > BTW,can you recommend a good book or tutorial for learning MS SQL server?
                >
                >
                > "Dan Guzman" <danguzman@nosp am-earthlink.net> wrote in message[/color]
                news:<yZnec.573 2$k05.1812@news read2.news.pas. earthlink.net>. ..[color=blue][color=green][color=darkred]
                > > > If it's in registry, whereis are there?[/color]
                > >
                > > For a default SQL 2000 instance:
                > >
                > > HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\MSSQLSe rver\MSSQLServe r\Parameters
                > >
                > > For a named SQL 2000 instance:
                > >
                > > HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\Microso ft SQL
                > > Server\[InstanceName]\MSSQLServer\Pa rameters
                > >
                > > --
                > > Hope this helps.
                > >
                > > Dan Guzman
                > > SQL Server MVP
                > >
                > > "Niy" <niy38@hotmail. com> wrote in message
                > > news:55dd405a.0 404111911.7a31a f1f@posting.goo gle.com...[color=darkred]
                > > > yes, that's what I mean.
                > > >
                > > > If it's in registry, whereis are there?
                > > >
                > > >
                > > > "Dan Guzman" <danguzman@nosp am-earthlink.net> wrote in message[/color]
                > > news:<NCJdc.394 3$A_4.1804@news read1.news.pas. earthlink.net>. ..[color=darkred]
                > > > > Assuming you're referring to SQL Server startup parameters, these[/color][/color][/color]
                are[color=blue][color=green][color=darkred]
                > > > > accessible from Enterprise Manager under the general tab of server
                > > > > properties. These are stored in the registry.
                > > > >
                > > > > --
                > > > > Hope this helps.
                > > > >
                > > > > Dan Guzman
                > > > > SQL Server MVP
                > > > >
                > > > > "Niy" <niy38@hotmail. com> wrote in message
                > > > > news:55dd405a.0 404082058.e7268 50@posting.goog le.com...
                > > > > > or in registry? where?[/color][/color][/color]


                Comment

                • Dan Guzman

                  #9
                  Re: which file store startup parameters?

                  One of my favorites for SQL Server admin and internals is Inside SQL Server
                  2000 <http://www.insidesqlse rver.com/index.html>.

                  --
                  Hope this helps.

                  Dan Guzman
                  SQL Server MVP

                  "Niy" <niy38@hotmail. com> wrote in message
                  news:55dd405a.0 404121931.da91b f3@posting.goog le.com...[color=blue]
                  > cool, thanks!
                  >
                  > BTW,can you recommend a good book or tutorial for learning MS SQL server?
                  >
                  >
                  > "Dan Guzman" <danguzman@nosp am-earthlink.net> wrote in message[/color]
                  news:<yZnec.573 2$k05.1812@news read2.news.pas. earthlink.net>. ..[color=blue][color=green][color=darkred]
                  > > > If it's in registry, whereis are there?[/color]
                  > >
                  > > For a default SQL 2000 instance:
                  > >
                  > > HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\MSSQLSe rver\MSSQLServe r\Parameters
                  > >
                  > > For a named SQL 2000 instance:
                  > >
                  > > HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\Microso ft SQL
                  > > Server\[InstanceName]\MSSQLServer\Pa rameters
                  > >
                  > > --
                  > > Hope this helps.
                  > >
                  > > Dan Guzman
                  > > SQL Server MVP
                  > >
                  > > "Niy" <niy38@hotmail. com> wrote in message
                  > > news:55dd405a.0 404111911.7a31a f1f@posting.goo gle.com...[color=darkred]
                  > > > yes, that's what I mean.
                  > > >
                  > > > If it's in registry, whereis are there?
                  > > >
                  > > >
                  > > > "Dan Guzman" <danguzman@nosp am-earthlink.net> wrote in message[/color]
                  > > news:<NCJdc.394 3$A_4.1804@news read1.news.pas. earthlink.net>. ..[color=darkred]
                  > > > > Assuming you're referring to SQL Server startup parameters, these[/color][/color][/color]
                  are[color=blue][color=green][color=darkred]
                  > > > > accessible from Enterprise Manager under the general tab of server
                  > > > > properties. These are stored in the registry.
                  > > > >
                  > > > > --
                  > > > > Hope this helps.
                  > > > >
                  > > > > Dan Guzman
                  > > > > SQL Server MVP
                  > > > >
                  > > > > "Niy" <niy38@hotmail. com> wrote in message
                  > > > > news:55dd405a.0 404082058.e7268 50@posting.goog le.com...
                  > > > > > or in registry? where?[/color][/color][/color]


                  Comment

                  Working...