Ms Sql 2000 script for BlogEngine.NET

For those interested, I've edited the default script that comes with BlogEngine.NET (1.3.0.0) so that it runs on MS SQL Server 2000 instead of 2005. You can download it here (14,23 kb). If there are any issues, feel free to contact me.

13 Replies to “Ms Sql 2000 script for BlogEngine.NET”

  1. I still get the below error when I used your script against ms sql 2000

    Msg 170, Level 15, State 1, Line 8
    Line 8: Incorrect syntax near ‘(‘.
    Msg 170, Level 15, State 1, Line 4
    Line 4: Incorrect syntax near ‘max’.
    Msg 170, Level 15, State 1, Line 7
    Line 7: Incorrect syntax near ‘(‘.
    Msg 170, Level 15, State 1, Line 4
    Line 4: Incorrect syntax near ‘max’.
    Msg 170, Level 15, State 1, Line 3
    Line 3: Incorrect syntax near ‘max’.
    Msg 170, Level 15, State 1, Line 8
    Line 8: Incorrect syntax near ‘(‘.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostCategory’ because this table does not exist in database ‘cancercompass’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostCategory’ because this table does not exist in database ‘cancercompass’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostCategory’ because this table does not exist in database ‘cancercompass’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostCategory’ because this table does not exist in database ‘cancercompass’.
    Msg 170, Level 15, State 1, Line 8
    Line 8: Incorrect syntax near ‘max’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostComment’ because this table does not exist in database ‘cancercompass’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostComment’ because this table does not exist in database ‘cancercompass’.
    Msg 170, Level 15, State 1, Line 8
    Line 8: Incorrect syntax near ‘(‘.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostNotify’ because this table does not exist in database ‘cancercompass’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostNotify’ because this table does not exist in database ‘cancercompass’.
    Msg 170, Level 15, State 1, Line 8
    Line 8: Incorrect syntax near ‘(‘.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostTag’ because this table does not exist in database ‘cancercompass’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostTag’ because this table does not exist in database ‘cancercompass’.
    Msg 170, Level 15, State 1, Line 5
    Line 5: Incorrect syntax near ‘(‘.
    Msg 170, Level 15, State 1, Line 5
    Line 5: Incorrect syntax near ‘(‘.
    Msg 170, Level 15, State 1, Line 5
    Line 5: Incorrect syntax near ‘(‘.
    Msg 170, Level 15, State 1, Line 5
    Line 5: Incorrect syntax near ‘(‘.
    Msg 170, Level 15, State 1, Line 5
    Line 5: Incorrect syntax near ‘(‘.

  2. Also, I copied your script from a Forum post on Codeplex and ran it against the database and it said the following error. Please let me know if you have found a solution to this problem. Thanks..

    Msg 156, Level 15, State 1, Line 9
    Incorrect syntax near the keyword ‘PRIMARY’.
    Msg 156, Level 15, State 1, Line 17
    Incorrect syntax near the keyword ‘PRIMARY’.
    Msg 156, Level 15, State 1, Line 18
    Incorrect syntax near the keyword ‘PRIMARY’.
    Msg 156, Level 15, State 1, Line 8
    Incorrect syntax near the keyword ‘PRIMARY’.
    Msg 156, Level 15, State 1, Line 9
    Incorrect syntax near the keyword ‘PRIMARY’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostCategory’ because this table does not exist in database ‘ccBlog’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostCategory’ because this table does not exist in database ‘ccBlog’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostCategory’ because this table does not exist in database ‘ccBlog’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostCategory’ because this table does not exist in database ‘ccBlog’.
    Msg 156, Level 15, State 1, Line 16
    Incorrect syntax near the keyword ‘PRIMARY’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostComment’ because this table does not exist in database ‘ccBlog’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostComment’ because this table does not exist in database ‘ccBlog’.
    Msg 156, Level 15, State 1, Line 9
    Incorrect syntax near the keyword ‘PRIMARY’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostNotify’ because this table does not exist in database ‘ccBlog’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostNotify’ because this table does not exist in database ‘ccBlog’.
    Msg 156, Level 15, State 1, Line 9
    Incorrect syntax near the keyword ‘PRIMARY’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostTag’ because this table does not exist in database ‘ccBlog’.
    Msg 4902, Level 16, State 1, Line 1
    Cannot alter table ‘dbo.be_PostTag’ because this table does not exist in database ‘ccBlog’.
    Msg 1906, Level 11, State 1, Line 2
    Cannot create an index on ‘dbo.be_PostCategory’, because this table does not exist in database ‘ccBlog’.
    Msg 1906, Level 11, State 1, Line 2
    Cannot create an index on ‘dbo.be_PostCategory’, because this table does not exist in database ‘ccBlog’.
    Msg 1906, Level 11, State 1, Line 2
    Cannot create an index on ‘dbo.be_PostComment’, because this table does not exist in database ‘ccBlog’.
    Msg 1906, Level 11, State 1, Line 2
    Cannot create an index on ‘dbo.be_PostNotify’, because this table does not exist in database ‘ccBlog’.
    Msg 1906, Level 11, State 1, Line 2
    Cannot create an index on ‘dbo.be_PostTag’, because this table does not exist in database ‘ccBlog’.

  3. I’ve been able to use this script with Query Analyzer, SQL Server Management Studio Express and SQL Server Management Studio all against a MS SQL 2000 DB. Maybe you are mixing up the files?

  4. Many thanks! This is an awesome script, and contrary to all the errors posted, it works straight away. I used it with OSQL.

  5. now i facing problem when i am running blog engine 2.0 in net 2008
    with sql server 2000

    Server Error in ‘/BlogEngine.Web’ Application.
    ——————————————————————————–

    Invalid object name ‘be_Rights’.

  6. The script here was only targeted at 1.3, you’ll have to dig in the code to figure out what is new and what not. I’m no longer using BlogEngine.NET so can’t help you at the moment.

Leave a Reply

Your email address will not be published. Required fields are marked *