What are the benefits of using SQL Server 2005 instead of SQL Server 2000 with the StrataFrame framework?

I think the largest advantages are these:



1. You get the ability to use the MAX data types (VarChar(MAX), NVarChar(MAX), VarBinary(MAX)) which can be indexed and are part of the actual table, rather than stored within a separate table.

2. You can take advantage of the Query Notification Services since the business objects will automatically register the notifications and raise the event when a notification is received.

3. You have the ability to use CLR stored procedures, so very complex stored procedures can be written in VB.NET or C# rather than in T-SQL.

4. You get the performance enhancements that SQL Server 2005 introduced.



Other than the Query Notification Services, StrataFrame doesn't treat the two databases differently. So, the differences you're going to see are going to be depended upon the database rather than dependent upon the way StrataFrame interacts with the database.