Post reply

SQL Server Express addition

  • March 18, 2009 at 5:07 am

    #131840

    Hi,

    May I know what is the difference between SQL Server and SQL Server express?

    I have a concern here. I am using the SQL Server original version 2000 in my development server and now customer migrated to sql server 2005 so I asked my mgr to change my development sql server 2000 to sql server 2005.

    He said that we can't get the license for SQL Server 2005, is it OK if you use 2005 express edition?

    I have an access applications which connect the sql server dbs internally. Will this migration of express edition impact on my Access applications?

    Kindly help me out in this concern. Thanks for your help.

    Thank You

  • March 18, 2009 at 5:25 am

    #961719

    Here you can see a comparsion of SQL Server 2005 versions:

    http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

    I would advice to ask your manager for the Developer Edition. Here is the pricing:

    http://www.microsoft.com/sqlserver/2005/en/us/pricing.aspx

    ... it contains all features of Enterprise Edition but is not allowed for production usage.

    Greets

    Flo

  • March 18, 2009 at 5:38 am

    #961726

    Florian Reischl (3/18/2009)

    Here you can see a comparsion of SQL Server 2005 versions:

    http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

    I would advice to ask your manager for the Developer Edition. Here is the pricing:

    http://www.microsoft.com/sqlserver/2005/en/us/pricing.aspx

    ... it contains all features of Enterprise Edition but is not allowed for production usage.

    Greets

    Flo

    Thanks for your information Florian....

    I have a sillyl doubt..... but I should ask otherwise I will not know.

    How can we check whether the SQL Server version is standard or express or enterprise edition.

    When I click on About in Help, I get only component names and versions with big numbers. it won't show that it is SQL server standard edition or Enterprise edition or express edtion.

    Can you let me know some info?

    Thank You

  • March 18, 2009 at 5:56 am

    #961737

    Hi Venki

    No silly question 😉

    Just execute following line in SQL Server Management Studio (or Query Analyzer):

    PRINT @@VERSION

    Greets

    Flo

  • March 18, 2009 at 11:48 pm

    #962492

    Florian Reischl (3/18/2009)

    Hi Venki

    No silly question 😉

    Just execute following line in SQL Server Management Studio (or Query Analyzer):

    PRINT @@VERSION

    Greets

    Flo

    Thanks a lot Flo.

    Thank You

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply