0

I am having sql server express edition local database in app_data folder.

How can i connect SQL Server Management Studio Expres with that db to execute sql scripts ?

d-man
  • 57,473
  • 85
  • 212
  • 296

2 Answers2

1

In Management Studio, right click databases, attach database and point to your mdf file.

thitemple
  • 5,833
  • 4
  • 42
  • 67
0

If it's an MDF file, SQL Management Studio can't open it.

This article might help: http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx

Dave Swersky
  • 34,502
  • 9
  • 78
  • 118