Post reply

Sql clinet to connect to the sql server 2005

  • January 13, 2011 at 8:52 am

    #230384

    is there any free software available, so that i can access the remote sql server 2005. My actual problem is i don't have any client tools and licence to install.

    i need to do some database development like writing procedures and creating some views.

    if i install sql server express edition will i able to connect to the server and access the information.

  • January 13, 2011 at 8:59 am

    #1273112

    Yes. You would be able to connect to other SQL Server instances using SSMS of Express Edition.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • January 13, 2011 at 9:04 am

    #1273115

    Adiga (1/13/2011)

    Yes. You would be able to connect to other SQL Server instances using SSMS of Express Edition.

    will be there any limitations? my remote sql server 2005 is an enterprice edition

  • January 13, 2011 at 9:19 am

    #1273123

    AFAIK, for any T-SQL query that you would execute using SSMS there is no limitations. However some of the advanced features available in the Enterprise Edition might not be accessible using the GUI.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • January 13, 2011 at 10:14 am

    #1273165

    Thanks adiga

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

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