home bbs files messages ]

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