QUESTION POSED ON: 16 October 2007 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?
>
EXPERT RESPONSE
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.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.
