Al,
>My ASP.NET app draws information from SQL Server to populate dropdown lists etc. This information changes very seldom and is common to all sessions so I'm storing it in datatables in Application state, which are loaded at application start.
Keeping this goal in mind. I don't think you need to restart the application. If you are to give the user an admin page (web form) which can be coded to retrieve the data from your SQL Server and repopulate the DataTables in your Application state so long as you can obtain a reference to the application state variable.
Just an idea,
HTH,
Dawa Tsering
"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."
- Ephesians 4:29-30 NIV
Dare to Question -- Care to Answer
Time is like water in a sponge, as long as you are willing you can always squeeze some.
--Lu Xun, Father of Modern Chinese Literature
