title: Cannot enable select into/bulkcopy on SQL Server 2005 database using sp_dboption
body: <p>I am trying to enable the select into/bulkcopy database option on a SQL Server 2005 database using the command:</p>
  
  <pre><code>EXEC sp_dboption 'mydbname', 'select into/bulkcopy', 'true'
  </code></pre>
  
  <p>After executing the above, running <code>EXEC sp_dboption 'mydbname', 'select into/bulkcopy'</code> tells me that the option is still set to OFF. </p>
  
  <p>I've confirmed that my Windows login is a user in the database and that it belongs to the db_owner role. Having read the <a href="http://msdn.microsoft.com/en-us/library/ms187310%28v=SQL.90%29.aspx" rel="nofollow">MSDN Documentation for sp_dboption</a>, this appears to be the only prerequisite for using the procedure to change options on a database.</p>
  
  <p>Are there any other steps or settings I am missing that could prevent me from being able to enable this option?</p>