SQL Server 2012 Compatibility I'm converting some stuff over to be compatible with SQL Server 2012 and had a couple of questions. I'm taking out all of the sp_dboption commands and making them ALTER commands instead, but there were a few options I haven't been able to tell the equivalent of. I was wondering if anyone here knew.

Here are the sp_dboptions I couldn't find:


bulkcopy
trunc. log
dbo use
single
ansi null default
db chaining


Here is the website I was using if it helps:

http://technet.microsoft.com/en-us/library/bb522682.aspx
They're all listed in Setting Database Options:


bulkcopy: ALTER DATABASE .. SET RECOVERY BULK_LOGGED;
trunc. log: ALTER DATABASE .. SET RECOVERY SIMPLE;
dbo use: ALTER DATABASE ... SET RESTRICTED_USER;
single: ALTER DATABASE ... SET SINGLE_USER;
ansi null default: ALTER DATABASE ... SET ANSI_NULL_DEFAULT ON;
db chaining: ALTER DATABASE ... SET DB_CHAINING ON;