Results 1 to 4 of 4

Thread: MSSQL Version

  1. #1
    Join Date
    May 2004
    Posts
    6

    Unanswered: MSSQL Version

    I have currently Standard Edition of MSSQL installed on my various servers. These servers are interacting with my one central server which also has Standard Edition of MSSQL.
    Please let me know if I change my central server Standard Edition of MSSQL to Enterprise Edition and keep the other server with the Standard Edition, will this effect the working ?
    Also please confirm, what are the changes in terms of query syntax or database setting that I will have to change for this change of version.

  2. #2
    Join Date
    Mar 2004
    Location
    London, UK
    Posts
    71

    Thumbs up

    i would not imagine there'd be any change required in your sql code as it remains fairly standard.

    if you change the central server to enterprise edition you will obviously have to do some reconfigurations, but that's a given when installing something new, but i wouldn't imagine anything too drastic.

    should connect and run well, good luck

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You can run a mix of Developer, Personal, Standard, and Enterprise versions of SQL Server with no problem. The Transact-SQL syntax is exactly the same on all of them, although there may be some SQL features that only exist on certain versions. As an example, clustering is only available to the Enterprise version, so you can't use clustering features in the Standard version, although the syntax would be the same if you could.

    -PatP

  4. #4
    Join Date
    May 2004
    Posts
    6
    Thanks a lot !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •