Problem solve Get help with specific problems with your technologies, process and projects.

Just installed SQL Server 2005 Express can't find database

Have you installed SQL Server 2005 Express Edition? Learn to find where the databases and stored procedures are stored.

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?
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 last published in October 2007

    Dig Deeper on Microsoft SQL Server 2005

    Have a question for an expert?

    Please add a title for your question

    Get answers from a TechTarget expert on whatever's puzzling you.

    You will be able to add details on the next page.

    Start the conversation

    Send me notifications when other members comment.

    By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

    Please create a username to comment.