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 17,605 of 19,505   
   Erland Sommarskog to tatata9999@gmail.com   
   Re: sql database creation and its ONLINE   
   07 Aug 09 22:02:26   
   
   9e1dfce1   
   From: esquel@sommarskog.se   
      
   Don84 (tatata9999@gmail.com) writes:   
   > On everything else, yeah, I wasn't careful, on "always use the -I   
   > option with SQLCMD to   
   > make sure that QUOTED_IDENTIFIER is ON,", even for calling a sql   
   > script to create a db and run a simple script for its verification?   
      
   I didn't mean to imply that you were sloppy by leaving it out. But since   
   I adviced you to use SQLCMD, it occurred to me that I should point   
   this out, since you may use SQLCMD for loading stored procedures and   
   whatnots in the future. But it is true that for just creating a   
   database, it is not likely to matter.   
      
   (Unless you script goes:   
      
      CREATE DATABASE "my new database"   
      
   of course, but 1) in that case you would notice pretty quick. 2) I've   
   never seen anyone to use double quotes with CREATE DATABASE, square   
   brackets seems to be a lot more common.)   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- 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