Hi there, I created my O/R Project on SqlServer 2000, now I want to use it with SqlServer 7. First thing that came into my mind was that SCOPE_IDENTITY doesnt work on SqlServer 7.

What is the best way to "downgrade" my project to SqlServer 7. Problem ist, that I cannot get my hands on the database directly, I just upload my .NET project via FTP, so recreating the project with SqlServer 7 is bit complicated.

Regards, André

The only real things that should change are: 1) globally replace SCOPE_IDENTITY() with @@IDENTITY in the generated code, this is in the entityfield factories (selfservicing) or in the persistenceinfofactory (adapter) 2) bigint types should change to int, as bigint isn't supported on sqlserver 7. If you use bigint types in your sqlserver 2000 project, you've to change long property types to int32 as well, which might be a bit of a problem.

Thanks a lot, Otis.