I've copied and pasted all of the stored procedures into the Query Analyzer to run install them on my own DB rather than thePhile db. but when I run the Analyzer I get this list of errors:
code page conversion not supported by data type of 'text'(I have traslated it).
This errors occurs in sp_News_UpdateNews ,sp_News_InsertNews and so on that have a field of 'text'type.But if I run these procedures in thePhile db,it works well.so I doubt that whether you set something when you create thePhile database.
If I modify the 'Body' field of News_News as 'varchar(1000)',it works well.so it's may be sql server 2000's problem,but I don't kown how to solve it.
I'm not a English Speaker.Can you understand?Can you help me?Thanks!

Can you post the stored procedures? I don't have the project and don't know what they do...

Brian

Do you have Service Pack 3 on your SQL Server? That will fix this error.

pgtips,you are right.I've solved this problem.Thanks!:)