Are the ratings related to the application that you have to build?
-Mike
>So, to do a transactional app the basic options are:
>
>(Best method)
>Put the objects in COM+, use declarative transactions with DTC by setting the supports/requires transaction flag of my package. This enables support of distributed transactions.
>
>(Secondary method)
>Use explicit transactions inside stored procedures. No distributed transaction support.
>
>(Third method)
>Code the transactions myself with either DB_TRANSMANUAL or DB_TRANSAUTO, either from a middle tier or the client app itself. This does allow the business rules to control the transactions.