well, there is some application used to carry out data import activity and it was working fine but once is upgrade the SQL server 2k5 from sp2 to sp4...

Hi the user xyz should need access to create the new database (dbcreator) and have the rights to import from flat files for newly created database ..

So should it will...

Hi Thanks ,

for update but my my requirement for client is to provide the user with DB creation & Import rights

DB creation is ok but I want to assing the...

BULKADMIN

BULK INSERT administrators. Can load data into tables using BULK INSERT statement.

Database administrators responsible only for loading data through BULK INSERT. Data import specialists.

So With Bulk Admin rights can...