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 |
|
eddie
Starting Member
45 Posts |
 Posted - 2002-01-18 : 11:52:47
|
| I have a stored procedure which uses dynamic sql to create a bulk insert from a text file. My problem is, I don't want the user to have to be in the sysadmin role to do this 'import'. Is there anyway around this??Thanks,Eddie |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-01-18 : 13:55:41
|
| There's also a BulkAdmin Server fixed role. I would search for bulkadmin on BOL. They will still need update permissions on the table(s) to be updated.JamesH. |
 |
|
|
eddie
Starting Member
45 Posts |
Posted - 2002-01-18 : 15:44:56
|
| Is this a feature in SQL 2000? I am using 7.Eddie |
|
|
|
izaltsman
A custom title
1139 Posts |
|
|
|
|
|
bulk insert not sysadmin