Get in queue for file open

[ivan.svaljek]

I'm trying to create a procedure that will take a subset of data from
sql server and store in an xml file.
The problem is that the xml file is read on every session/page refresh,
so there is a possibility for collision, since there is a function in
global.asax that refreshes the xml file every x minutes.
Is it possible to check the file open status from global.asax and get
in queue for the next exclusive file open?

 

[bruce barker \(sqlwork.com\)]

good case for the singleton pattern.

-- bruce (sqlwork.com)