I am trying to upload a list of Users in Roles to a remote shared SQL 2005 server. I have my database and want to upload a TAB delimited text file of 'UserId' and 'RoleId' to APPEND to existing records.
My Error is "You do not have permission to use the bulk load statement."
How do I modify security for my role, or the database to gain permission to perform the task without being 'sysadmin', and if you advise bulkadmin where is it, as i have seen it as a solution but am unable to locate it in SSMSE2005.
Will the script below suffice or does it need more syntax or field declarations?
BULK INSERT aspnet_UIR