Looking for SQL Server Instance

Posted on 2009-02-20
Last Modified: 2013-11-26

I'm trying to use the developer version of SQL Server 2005 that came with Visual Studio 2005 and/or 2008.  Where can I find what it's called, how to access it, etc.?

Question by:NigelRocks
    LVL 24

    Accepted Solution

    The developer version that comes with Visual Studio 2005/2008 is SQL Express.  It does not come with tools nor does it really act like SQL Server by default, but it can be made to act like it.

    To see it you would need to download SQL Server Management Studio Express from and the instance of sql is by default:

    LVL 48

    Expert Comment

    You can work with the attached databases ...
    In your project create a new item and choose *.mdf.
    Then in the server explorer (view - server explorer) you can create tables, views, stored procedures, etc.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now