Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 18,523 of 19,505    |
|    Tony to All    |
|    What is the difference between create a     |
|    24 Nov 11 12:26:22    |
      From: johansson.andersson@telia.com              Hello!              I can create a database in solution explorer in the following way.       1. Right click the project choose add new item       2. Choose a SQL Server Database       3 You get a question if you want to add the database to App_Data              When you have done this the database will also appear in the Server Explorer       with extension mdf       The created database does not exist within the list of available databases       in sql server Management Studio              I can also create a database from server Explorer in the following.       1.Right click on the Data Connection and choose Create new SQL server       Database       2.A dialog (Create New SQL Server Database) appear.       3. Choose what server for example the default server instance or perhaps the       named express instance       4.Give the database a name.       5 Now the database appear in the Server explorer with extension dbo       The created database also appear within the list of available databases in       sql server Management              Now to my question what is the difference between these two ways to create a       database ?       I mean when I used the first way the SQL server must be used even though the       database didn't appear in the list of available databases in SQl Server       Management studio.              These are some obvious differences for example.       1. I can't access the database from within SQL Server because it does not       exist here       2. In both ways I can access the database from the Server explorer              //Tony              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca