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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-10 : 08:06:58
|
| Martin writes "I´m trying to execute a Stored Procedure and I´ve got the next message "Operating system error code 5(Access is denied.)" .The next text is the SP *************************************************CREATE PROCEDURE sp_ImportFile@FileName varchar(200) ASDECLARE @SQL varchar(2000)SET @SQL = 'BULK INSERT intrarequisition.dbo.Historico FROM ''\\MyServer\MyFolder\' + @FileName + ''' WITH (FIELDTERMINATOR ='','')'Exec(@SQL)**********************************PD. If I give permissons the "everyone" group to the folder "MyFolder", everything works fine, How can I resolve this?, Which group I must grant permissons to the folder" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-10 : 12:04:15
|
| It needs to be granted to the group that is executing the stored procedure. You could just grant read permissions to everyone.Tara |
 |
|
|
|
|
|
Operating system error code 5(Access is denied.)