Everything is working perfectly. I have everything up and running correctly!!!

Just installed AS 1.4 and am getting the following on a members view:


DotNetNuke.Services.Exceptions.ModuleLoadException: Incorrect syntax near 'PIVOT'. You may need to set the c
The database is
Microsoft SQL Server 2005 - 9.00.3080.00 (Intel X86) Sep 6 2009 01:43:32 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

I am currently trying to determine the compatibility level of my database.

Please create a ticket or use the support forum.

Never mind, a long time ago when I transferred my site it must have gone from 2000 to 2005 but kept the compatibility level of 80 (sql 2000)
I simply ran the sql to change to compatibility level 90 (sql 2005).

All is well again.

Worth knowing about though.

This is the script to run in Host > SQL as recommended by my hoster:

declare @DBName nvarchar(1000)
declare @CompatibilityMode int
set @DBName = db_name()
set @CompatibilityMode = 90
EXEC sp_dbcmptlevel @DBName, @CompatibilityMode;

You shouldn't have been able to install Active Forums or Active Social successfully running under 2000 compatibility mode. I'm surprised you haven't received install errors before.

Posted By fatgeorge on 11 Feb 2010 12:14 PM
This is the script to run in Host > SQL as recommended by my hoster:

declare @DBName nvarchar(1000)
declare @CompatibilityMode int
set @DBName = db_name()
set @CompatibilityMode = 90
EXEC sp_dbcmptlevel @DBName, @CompatibilityMode;

What is the SQL command to see what the current setting is?

as far as I can see it should be:

declare @DBName nvarchar(1000)
set @DBName = db_name()
EXEC sp_dbcmptlevel @DBName

But it wouldn't return anything, I knew I had gone from sql 2000 to 2005 but didn't realise the compatibility had been set to 80.
I decided to just run it and see. (making sure I had a recent backup!)

I have a dumb question: do I need to replace "db_name" with my site's db name? I ran above script without changing the "db_name" into my site's db name. Even though it worked but I am worried that could've caused some problems.

That is just a flag, nothing is changed in the database itself, the software accessing the database will use different queries depending on the value of the compatibility mode flag.

I'm checking mine now, I too have upgraded the database from 2000 to 2005 to 2008 over the last few years, so I want to see if that might be an issue.

Hmmmmmm, apparently mine is set for SQL 2000 mode also. Might explain some of the issues I've been experiencing.

Same issue here. Your script resolved it quickly. Thank you!