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:



What Makes A Software Programmer a Professional? - CodeProject

Summary article written by Rob Kraft in  https://www.codeproject.com/Articles/5129182/What-Makes-A-Software-Programmer-a-Professiona...