Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Windows Run Command

Windows Run Command

Scheduled Pinned Locked Moved Database
databasesql-serversysadminhelpquestion
18 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • L Lost User

    Your big black writing is not appreciated, normal font size and weight is perfectly adequate for all questions. As to your query, I don't know if that will work, you will need to look at the instructions for installing SQL Express.

    One of these days I'm going to think of a really clever signature.

    J Offline
    J Offline
    jojoba2011
    wrote on last edited by
    #8

    thanks for attention. But i am working on it but no idea and doesnt get ans. Plz help!

    L 1 Reply Last reply
    0
    • J jojoba2011

      thanks for attention. But i am working on it but no idea and doesnt get ans. Plz help!

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #9

      jojoba2011 wrote:

      no idea and doesnt get ans.

      As I said, you need to look at the instructions for installing SQL Express. Most products come with an installer that allows you to select the destination directory, but I do not know if you can do it with environment variables.

      One of these days I'm going to think of a really clever signature.

      J 1 Reply Last reply
      0
      • L Lost User

        jojoba2011 wrote:

        no idea and doesnt get ans.

        As I said, you need to look at the instructions for installing SQL Express. Most products come with an installer that allows you to select the destination directory, but I do not know if you can do it with environment variables.

        One of these days I'm going to think of a really clever signature.

        J Offline
        J Offline
        jojoba2011
        wrote on last edited by
        #10

        I didnt get any thing from it. Will you also check something for me.? Thanks in advanced !

        L 1 Reply Last reply
        0
        • J jojoba2011

          I didnt get any thing from it. Will you also check something for me.? Thanks in advanced !

          L Offline
          L Offline
          Lost User
          wrote on last edited by
          #11

          jojoba2011 wrote:

          I didnt get any thing from it.

          That probably means that there is no option to provide what you want.

          One of these days I'm going to think of a really clever signature.

          1 Reply Last reply
          0
          • J jojoba2011

            thanks for solution. but i dont understand where should i run that command or how to use that. My main Question is that : Is it possible to change "MSSQL.**x**" In this address "c:\Program Files\SqlServer 2005 for DWebPro\MSSQL.1\MSSQL" while installing sql express 2005 in command line? So that it wont generate it Automatically. I mean that i give that number while wanna install sql express 2005. Or More Clearly : I wanna change Instance Id and give my own Id while installing sql express 2005 ! Thanks in Advanced!

            L Offline
            L Offline
            Lost User
            wrote on last edited by
            #12

            There's a difference between the installation path, and an install-ID. If I understand you correctly, you're having trouble identifying which of the Sql Server-instances that's on the machine is yours. Is that correct, so far?

            Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

            U 1 Reply Last reply
            0
            • L Lost User

              There's a difference between the installation path, and an install-ID. If I understand you correctly, you're having trouble identifying which of the Sql Server-instances that's on the machine is yours. Is that correct, so far?

              Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

              U Offline
              U Offline
              User 9427106
              wrote on last edited by
              #13

              Hi..thanks a lot...thats exactly correct but before installing i my self should give that value to sql express setup cause that value is static in my project.

              L 1 Reply Last reply
              0
              • U User 9427106

                Hi..thanks a lot...thats exactly correct but before installing i my self should give that value to sql express setup cause that value is static in my project.

                L Offline
                L Offline
                Lost User
                wrote on last edited by
                #14

                Member 9473809 wrote:

                thats exactly correct but before installing i my self should give that value to sql express setup

                You're explaining what you "want" the software to do, not quite what you're trying to achieve. One can install Sql Server from the command prompt[^]. That way you could also predefine in which directory the app will be installed. A word of warning here; you'll be working under the assumptions that you have read/write rights in that location, and that the location exists. Both assumptions would fail on a networked PC here. What's more, most machines already have Sql Server, and it'd be preferable to hook up the database for a new app to one of the existing servers. Your app would fail again if someone moved the database to a different server. Here's the catch; I'm still wondering why you need to "know" this path. It's defined at install, fine, you could have a custom action in there that writes to the registry where it'll be located. In fact, you can "ask" Sql Server for it's storage- and backup-locations. What kind of data are you storing in there, and what kind of app are we talking about?

                Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

                J 1 Reply Last reply
                0
                • L Lost User

                  Member 9473809 wrote:

                  thats exactly correct but before installing i my self should give that value to sql express setup

                  You're explaining what you "want" the software to do, not quite what you're trying to achieve. One can install Sql Server from the command prompt[^]. That way you could also predefine in which directory the app will be installed. A word of warning here; you'll be working under the assumptions that you have read/write rights in that location, and that the location exists. Both assumptions would fail on a networked PC here. What's more, most machines already have Sql Server, and it'd be preferable to hook up the database for a new app to one of the existing servers. Your app would fail again if someone moved the database to a different server. Here's the catch; I'm still wondering why you need to "know" this path. It's defined at install, fine, you could have a custom action in there that writes to the registry where it'll be located. In fact, you can "ask" Sql Server for it's storage- and backup-locations. What kind of data are you storing in there, and what kind of app are we talking about?

                  Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

                  J Offline
                  J Offline
                  jojoba2011
                  wrote on last edited by
                  #15

                  I have read that before but isnt possible to give my own number to MSSQL.x .it creates automatically when wanna install sql. my main question is how can i give that number my self when wanna install sql express 2005 in command Prompt ? Thanks in advanced !

                  L 1 Reply Last reply
                  0
                  • J jojoba2011

                    I have read that before but isnt possible to give my own number to MSSQL.x .it creates automatically when wanna install sql. my main question is how can i give that number my self when wanna install sql express 2005 in command Prompt ? Thanks in advanced !

                    L Offline
                    L Offline
                    Lost User
                    wrote on last edited by
                    #16

                    You can't, you can only modify what's mentioned in the article.

                    Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

                    J 1 Reply Last reply
                    0
                    • L Lost User

                      You can't, you can only modify what's mentioned in the article.

                      Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

                      J Offline
                      J Offline
                      jojoba2011
                      wrote on last edited by
                      #17

                      hi sir, i wanna run setup via command prompt so will you please check that if its possible that to mentian that MSSQL.x in setup custom. My english isnt well. thanks in advanced!

                      L 1 Reply Last reply
                      0
                      • J jojoba2011

                        hi sir, i wanna run setup via command prompt so will you please check that if its possible that to mentian that MSSQL.x in setup custom. My english isnt well. thanks in advanced!

                        L Offline
                        L Offline
                        Lost User
                        wrote on last edited by
                        #18

                        You can use Google Translate to go from English to your language. There are no alternatives to the ones mentioned in the documentation. Hence, you'll have to find another way to do what you need.

                        Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

                        1 Reply Last reply
                        0
                        Reply
                        • Reply as topic
                        Log in to reply
                        • Oldest to Newest
                        • Newest to Oldest
                        • Most Votes


                        • Login

                        • Don't have an account? Register

                        • Login or register to search.
                        • First post
                          Last post
                        0
                        • Categories
                        • Recent
                        • Tags
                        • Popular
                        • World
                        • Users
                        • Groups