james_burd

Is there a way to do the opposite? I want to convert a SQL table to XML.

Is there a minimum client version that is needed? Or does only the database need to be updated? I have installed a newer version, set the expiration to 1 day but the offline user (that did not update his version) did not expire?

Also, what is the behavior once the offline session expires? Will they be prompted to connect online? Will they attempt to connect to a session and be met with a pop up telling them their offline mode has expired?

I believe that even most of the data stored in the database is encrypted. I think what would work here (and I have suggested) is an offline expiration policy. That way if the computer is lost\stolen the offline mode would expire and become unusable unless they could connect to the SQL server again. He has agree'd to add the expiration policy but I am not sure when.

Is there an ETA on the expiration policy update?

I will explain what I am looking for. We are a company that has many users not connected to the same network where I have installed the SQL server. I would like the the users not on the same network to be able to connect to the server to get the data source session info. Then be able to go offline and retain the info on their local machine. All of that currently works. Here is the new feature:

Make users that connect via offline mode log in to the server once a day to get updated session info and also to make sure their user account is still a valid user account.

For ex-employees, I do not want them to have the connection info stored in off-line mode forever.

edited by james_burd on 7/18/2011