Q

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

    Dig deeper on Microsoft SQL Server 2005

    Pro+

    Features

    Enjoy the benefits of Pro+ membership, learn more and join.

    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.

    0 comments

    Oldest 

    Forgot Password?

    No problem! Submit your e-mail address below. We'll send you an email containing your password.

    Your password has been sent to:

    -ADS BY GOOGLE

    SearchBusinessAnalytics

    SearchDataCenter

    SearchDataManagement

    SearchAWS

    SearchOracle

    SearchContentManagement

    SearchWindowsServer

    Close