SqlBulkCopy Tutorial - Knowledge Base (KB)

Is it feasible to use SqlBulkCopy without the db datawriter permission in SQL 2008?

I want to limit my database possible access ways to only using stored procedures. Everything works fine except ...System.Data.SqlClient.SqlBulkCopy.... I'm using it only in one class for massive data import....Is it possible to avoid this problem?...I tri...

In SQL 2008, which right allows a user to assign himself another right?

I need to grant a ...db_datawriter... before executing ...SqlBulkCopy... and remove it after:...try { "EXEC [db_mod].[sys].[sp_addrolemember] N'db_datawriter', N'my_user'" // via SqlCommand bulk.WriteToServer(table); } finally { "EXEC [db_mod].[s...

Is SqlBulkCopy the best method for bulk inserts?

I am developing an online tool in .NET 4 to read potentially large (thousands of rows) Excel pages into a DataTable and then using SqlBulkCopy.WriteToServer() to upload to a matching Sql Server 2000 (soon to be 2008) table. It is only for use within my co...