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.
.net developer with a touch of Cocoa
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.
Great, This comes in very handy!
Thanks a lot.
regards,
Peter.
your link to the new file points to the same old 2005 file instead of the 2000 file.
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 ‘(‘.
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’.
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?
Nice Post!
Many thanks! This is an awesome script, and contrary to all the errors posted, it works straight away. I used it with OSQL.
Great post.
The Script works fine. Do you have a script for BE 1.5? Thank you
this is a really fine script .) i like it very much 🙂 thanks for sharing this great work 🙂
regards
Tanja
its nice , very help full thx a lot
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’.
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.