GO
Permissions
Requires INSERT and ADMINISTER BULK OPERATIONS permissions. Additionally, ALTER TABLE permission is required if one or more of the following is true:
Constraints exist and the CHECK_CONSTRAINTS option is not specified.
Note Note
Disabling constraints is the default behavior. To check constraints explicitly, use the CHECK_CONSTRAINTS option.
Triggers exist and the FIRE_TRIGGER option is not specified.
Note Note
By default, triggers are not fired. To fire triggers explicitly, use the FIRE_TRIGGER option.
You use the KEEPIDENTITY option to import identity value from data file.
http://msdn.microsoft.com/en-us/library/ms188365.aspx
Regards,
Libras