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 |
|
sagitariusmzi
Posting Yak Master
113 Posts |
 Posted - 2010-01-15 : 01:42:01
|
| Hi, I have to come know that security of the files saved on the local drive using Filestream is managed by the sql server itself. When i deleted that file from NTFS , it allowed me to delete the file. but when i executed the query SELECT * FROM dbo.FileStreamTableit given me the error Msg 233, Level 20, State 0, Line 0A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)Why the file was deleted from the local path (instead it should be deleted from sql server because the security was managed by FileStream)Regards |
|
|
|
|
|
Delete of Filestream file from Local NTFS