SqlBulkCopy Tutorial - Knowledge Base (KB)

Is it possible to use SqlBulkCopy in SQL 2008 without permission 'db_datawriter'?

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...

Which right grants user a right to grant another right to himself in SQL 2008?

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 approach for regular 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...