Here is the way you can connect ASP.net local SQL server database to SQL Server management studio and get the full operations with Server Management Studio.
Step 1: Open the SQL Server Management studio 2005. Right click on Database and Select Attach.
Step 2: Attach Database dialog opened, Now click on Add button at bottom.
Step 3: Locate Database MDF file Dialog opened, Now browse the mdf file and select it. Click on Ok button at bottom.
Step 4: Attach Database is visible in parent dialog Now click on ok bottom at bottom..
If MDF is in correct format, it will display the attach database successfully otherwise display error.
0 comments:
Post a Comment