Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 27, 2010 12:35 PM by adeelehsan
Nov 27, 2010 07:54 AM|LINK
What is the difference between adding connection from the database explorer and adding new item->sql server database file in the solution explorer? both are connecting to database. In the former im getting the
<myhost name>\sqlexpress.<my database name>.dbo in database explorer, but in the later im getting the
<databasename>.mdf file containing table,stored procedures etc in the solution explorer
Nov 27, 2010 12:35 PM|LINK
When you add a database connection in the server explorer, you do not create a new database. You just create a connection to an existing database which can be on any accessible server.
Where as when you add a new sql server database, it will create a new .mdf database file and at the same time will how the structure of it which is initially empty.