SQL DDL error against SQL 2000

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Execute the SQLServer.sql script against SQL 2000

What is the expected output? What do you see instead?

Expect the creation of the ELMAH tables and stored procedures and I 
receive "invalid object" errors.

What version of the product are you using? On what operating system?

ELMAH Beta3

Please provide any additional information below.

It works if I change:

SELECT 
    @DBCompatibilityLevel = compatibility_level 
FROM 
    sys.databases 
WHERE 
    name = DB_NAME()

to:

SELECT 
    @DBCompatibilityLevel = cmptlevel 
FROM 
    master.dbo.sysdatabases 
WHERE 
    name = DB_NAME()

Original issue reported on code.google.com by ulfiu...@gmail.com on 20 Nov 2008 at 11:03

[GoogleCodeExporter]

Original comment by azizatif on 20 Nov 2008 at 11:05

• Added labels: Component-Scripts

[GoogleCodeExporter]

Original comment by azizatif on 20 Nov 2008 at 11:14

• Changed state: Accepted
• Added labels: Milestone-Release1.0, Priority-Critical
• Removed labels: Priority-Medium

[GoogleCodeExporter]

Fixed in r528. Thanks.

Original comment by azizatif on 20 Nov 2008 at 11:22

• Changed state: Fixed

[GoogleCodeExporter]

Attached updated script.

Original comment by azizatif on 20 Nov 2008 at 11:52

Attachments:

• SQLServer.sql

[GoogleCodeExporter]

Original comment by azizatif on 21 Nov 2008 at 7:52

• Added labels: Affects-1.0B3