«
»

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.

Tags: , ,

This entry was posted on Thursday, April 3rd, 2008 at 21:38 and is filed under Computer. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

10 Responses to “Ms Sql 2000 script for BlogEngine.NET”

  1. Peter Kassenaar says:
    April 6, 2008 at 23:40

    Great, This comes in very handy!

    Thanks a lot.

    regards,
    Peter.

  2. dhaval says:
    May 6, 2008 at 01:30

    your link to the new file points to the same old 2005 file instead of the 2000 file.

  3. dhaval says:
    May 6, 2008 at 01:25

    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 ‘(‘.

  4. dhaval parekh says:
    May 6, 2008 at 03:42

    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’.

  5. Benny Michielsen says:
    May 6, 2008 at 10:45

    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?

  6. Catto says:
    May 21, 2008 at 20:20

    Nice Post!

  7. Saumil Shah says:
    June 12, 2008 at 14:27

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

  8. waggi says:
    December 2, 2009 at 03:07

    Great post.

  9. Joel says:
    December 3, 2009 at 19:58

    The Script works fine. Do you have a script for BE 1.5? Thank you

  10. Tanja Hammerl says:
    March 30, 2010 at 15:26

    this is a really fine script .) i like it very much :) thanks for sharing this great work :)

    regards
    Tanja

Leave a Reply