Saturday, May 16, 2015

Northwind Sample DB Script is not work on SQL 2014

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

GPG Verify DupeGuru

https://dupeguru.voltaicideas.net/ https://github.com/arsenetar/dupeguru/releases/tag/4.3.1 $ gpg --verify dupeguru_macOS_Qt_4.3.1.zip.siggp...