New Feature SQL-74
1 vote

Make a variant of the Simple schema that works on pre-2005 SQL Server

Created by Rob Vesse on 8/25/2011 12:59 PM Last Updated by Rob Vesse on 8/25/2011 2:31 PM
%
 (hrs)
Logged: 0  (hrs)

 Description

The Simple schema still uses computed columns which are only in SQL Server 2005 and later.  Make a modified version of the schema that doesn't use computed columns and just computes the values in the relevant stored procedures instead

    Rob Vesse (Thursday, August 25, 2011 2:31 PM) #

Modified schema appropriately and runs fine using SQL Server 2000 compatability mode on Server 2008 but no guarantee it actually runs on the real thing