Yes, it does keep a Tx. log. And, I have it on good authority that integrated security is in fact, supported. Based on the website, when you install MSDE, you have the SQL-DMO objects at your disposal. If this is true, then you can define users, roles, etc.
>Hi JVP -----
>
>I agree. With the need for strong security and transaction logging, a dedicated server database is required regardless of topology. DBFs fall down in that respect. I haven't played with MSDE too mush; does it keep a trnxlog?
>
>
>>OK John, consider this scenario:
>>
>>I have a data-set that will never grow beyond 10 mb's. However, the data set contains confidential information and needs inherent security. Also, because of certain requirements, a detailed transaction log needs to be kept.
>>
>>Is the data-set small? Yes.
>>Will DBF's work? No.
>>
>>I could have taken this example further to really skew it toward SQL-Server, or some other server RDBMS. Then again, I did'nt have to.
>>
>>This is an interesting discussion. Let's keep it going...
>>
>>
>>
>>>>
>>If an application is never going to grow beyond a set, reasonable amount of users I was advocating sticking with the good ole DBF format.
>><<
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only