Just installed SQL Server 2005 Express can't find database

I have installed SQL Server 2005 Express Edition. Where (what folder) on my hard disk will the databases I create be stored? Can you also tell me where to find the stored procedures?

    Requires Free Membership to View

    Login

    By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

SQL Express stores databases in the same way as any other edition of SQL Server. All databases are stored in the default data folder in your installation path. If this is your first installation of SQL Server, that path is C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData. All stored procedures will be stored inside the database for which they were created.

Check out this helpful tip:   
  • SQL Server 2005 Express vs. Desktop Engine (MSDE)
    SQL Server 2005 Express Edition and the SQL Server Desktop Engine (MSDE) each provides a medium where database administrators can work before leaping to the full version of SQL Server. Windows expert Serdar Yegulalp examines these products to help you decide which is best for your environment.

    • This was first published in October 2007

    Join the conversationComment

    Share
    Comments

      Results

      Contribute to the conversation

      All fields are required. Comments will appear at the bottom of the article.
      Back to top