Database File Dependancies

Hi

I am trying to set-up a Cached table with a file dependancy.

I use a trigger to write out the DateTime() to a text file every time the table has an Update,Insert or Delete performed on it. When I firts look at the table in my App, I set the table up in the cache using a file dependancy on the text file.

The stored procedure currently writes out DateTime.txt to the c:\ drive of my test server.

Have I got the luxury of a c:\ drive on the SQL server?

if so, how would you recommened I name the file? (I imagine if i put my username at the start, this will end up unique anyway)

 

quote:Originally posted by bruce
I don't believe you can do that.
</blockquote id="quote"></font id="quote">

Shame, have to leave caching in that case :¬(