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?
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