Learn More





DNN Community Blog

The Community Blog is a personal opinion of community members and by no means the official standpoint of DNN Corp or DNN Platform. This is a place to express personal thoughts about DNNPlatform, the community and its ecosystem. Do you have useful information that you would like to share with the DNN Community in a featured article or blog? If so, please contact .

The use of the Community Blog is covered by our Community Blog Guidelines - please read before commenting or posting.

Generating SQL 2000 compatible scripts

DotNetNuke has had SQL 2000/MSDE 2000 as one of it's supported databases since they were released. Whilst it's getting harder to justify it (Microsoft themselves ended mainstream support for SQL Server 2000 on 8th April 2008 ), we still take care each release to ensure that the database scripts are compatible with SQL 2000.

However I've noticed a few errors creeping in from time to time in our code. These come about as most developers are running SQL 2005/2008 in their development environment. When you use the script generating tools in SQL Server Management Studio (SSMS) it generates script that is valid for that version of SQL. Often this SQL will still work in earlier versions such as SQL 2000, but on occasion it contains syntax that will cause an error on SQL 2000.

There is a workaround for this. When generating scripts, rather than right-clicking on a table to generate a CREATE script, right-click on the Database itself and select "Tasks" -> "Generate Scripts". This will open the "Generate SQL Server Script Wizard". Click next, then select your database and click next again. Now scroll down a little and find the "Script for Server Version" property and set it to "SQL Server 2000". This will ensure that any scripts created only contain features compatible with that version.

Note: I would encourage anyone running DotNetNuke against SQL 2000/MSDE 2000, to consider upgrading to at least SQL 2005 or above at their earliest opportunity. Unless you've purchased extended support from Microsoft you're running an unsupported version, and I would not expect DotNetNuke to continue to support a 9 year old database server for ever. In addition SQL 2005 (and above) add many new constructs such as common table expressions, pivots/unpivots, XML datatypes and enhance existing datatypes such as VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX), that would be useful in enhancing and improving a number of areas both in the core and modules.


Comment Form

Only registered users may post comments.


2sic Daniel Mettler (124)
Aderson Oliveira (15)
Alec Whittington (11)
Alex Shirley (10)
Andrew Nurse (30)
Anthony Glenwright (5)
Antonio Chagoury (28)
Ash Prasad (21)
Ben Schmidt (1)
Benjamin Hermann (25)
Benoit Sarton (9)
Beth Firebaugh (12)
Bill Walker (36)
Bob Kruger (5)
Brian Dukes (2)
Brice Snow (1)
Bruce Chapman (20)
Bryan Andrews (1)
cathal connolly (55)
Charles Nurse (163)
Chris Hammond (203)
Chris Paterra (55)
Clinton Patterson (28)
Cuong Dang (21)
Daniel Bartholomew (2)
Dave Buckner (2)
David Poindexter (3)
David Rodriguez (2)
Doug Howell (11)
Erik van Ballegoij (30)
Ernst Peter Tamminga (74)
Geoff Barlow (6)
Gifford Watkins (3)
Gilles Le Pigocher (3)
Ian Robinson (7)
Israel Martinez (17)
Jan Blomquist (2)
Jan Jonas (3)
Jaspreet Bhatia (1)
Jenni Merrifield (6)
Joe Brinkman (269)
John Mitchell (1)
Jon Henning (14)
Jonathan Sheely (4)
Jordan Coopersmith (1)
Joseph Craig (2)
Kan Ma (1)
Keivan Beigi (3)
Ken Grierson (10)
Kevin Schreiner (6)
Leigh Pointer (31)
Lorraine Young (60)
Malik Khan (1)
Matthias Schlomann (15)
Mauricio Márquez (5)
Michael Doxsey (7)
Michael Tobisch (3)
Michael Washington (202)
Mike Horton (19)
Mitchel Sellers (28)
Nathan Rover (3)
Navin V Nagiah (14)
Néstor Sánchez (31)
Nik Kalyani (14)
Peter Donker (52)
Philip Beadle (135)
Philipp Becker (4)
Richard Dumas (22)
Robert J Collins (5)
Roger Selwyn (8)
Ruben Lopez (1)
Ryan Martinez (1)
Salar Golestanian (4)
Sanjay Mehrotra (9)
Scott McCulloch (1)
Scott S (11)
Scott Wilkinson (3)
Scott Willhite (97)
Sebastian Leupold (80)
Shaun Walker (237)
Shawn Mehaffie (17)
Stefan Cullmann (12)
Stefan Kamphuis (12)
Steve Fabian (31)
Timo Breumelhof (24)
Tony Henrich (3)
Torsten Weggen (2)
Vicenç Masanas (27)
Vincent Nguyen (3)
Vitaly Kozadayev (6)
Will Morgenweck (37)
Will Strohl (163)
William Severance (5)
Try Evoq
For Free
Start Free Trial
a Demo
See Evoq Live
Need More Information?