Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BigRetina
Posting Yak Master
144 Posts |
 Posted - 2002-11-05 : 02:27:30
|
| Salute..Will there be a problem if I use a stored procedure to write to a file..using echo for example..and concurrent users are calling the same stored procedure!..?..is this concurrency solved by the SQL server itself?..otherwise what shall I do to be sure the if an sp is writing to the file other users wont be blocked!!Thanks In Advance |
|
|
ashok
Yak Posting Veteran
57 Posts |
Posted - 2002-11-05 : 06:34:15
|
| No, i dont think sql server will take care of concurrency issues for files in the file system. Why dont you try creating a unique operating system file for each user using something like NewID(), you will just have to remember to clean up / delete the file at the end of the stored procedure...-ashok"Bad dancing does not break an engagement." |
 |
|
|
|
|
|
Locking a FILE in SQL