Timbo
12-03-2003, 06:32 AM
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)
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)