FAQs
      Back to home
      1. Idealpos Help Guides
      2. Idealpos
      3. FAQs

      How to locate the SQL Edition installed

      How to locate the SQL Edition installed

      How to locate details on the SQL Edition installed:
      1. Open IPSutils
      2. Go to the Advanced TAB
      3. Select the SqlCmd Line Button
      4. A 1> will be displayed

      5. Type Select @@version & press ENTER

      6. Type Go & Press Enter

      7. Details like below will be displayed

      8. Once you have finished type Exit & press ENTER to close the screen

      Note that when restoring a customer database, if the message Database Mismatch displays, one of the reasons could be because you are restoring into an earlier version of SQL Server than is being used on the PC that is the source of the database. Use the above command to determine what SQL Server version you will need to run to restore the database.