Facing issue during database deployment

Legacy Uncategorised
1

I am using octopus to deploy database in SQL Server 2012 instance. It holds several tables and procedures. When deploying the database ,I landed up with the below error. When checked I noticed that system procedure sp db_options is not available in sql server 2012 instance. Please help me in this regard.

Msg 2812, Level 16, State 62, Server RR1ALHSTPRO769\MSSQLSERVER2012, Line 45
Could not find stored procedure ‘sp_dboption’.

2

Hi Ajay,

Microsoft deprecated this procedure in SQL 2012 - apparently you can use ALTER DATABASE instead:

http://connect.microsoft.com/SQLServer/feedback/details/723806/sql-server-2012-rc0-missing-master-sys-sp-dboption-stored-procedure

Paul