Comment out the line #24-25 in file "SQL Server 2000 Sample Databases\instnwnd.sql"
sp_dboption removed after SQL 2012
-- exec sp_dboption 'Northwind','trunc. log on chkpt.','true'
=> ALTER DATABASE Northwind SET RECOVERY SIMPLE
-- exec sp_dboption 'Northwind','select into/bulkcopy','true'
=> ALTER DATABASE Northwind SET RECOVERY BULK_LOGGED
Referenece:
No comments:
Post a Comment