Questions On LogFiles: SQL Express 2005

Note: Please refer to my previous message to see the current VS2005 C# code I am using to create my database.



This database will be used for short term operations. In otherwords, a user will create the database, generate a lot of data that will be created using:

SqlBulkCopy bcp;

Then, there will be 'activity'... updates, queries, deletes, etc for a few days and then the user will at a minimum remove all of the data and at some future point in time, will recreate the data and do the process all over.



In otherwords, I am not concerned about backups or transaction logging or recovery or any of these 'normal' issues of using a SQL database.



That said, how do I use SMO to keep the LDF limited in size and as small as possible (assuming I can't turn of the tranaction log to begin with).



2nd question is...I read soething about being able to log ONLY the exection of a Bulk Copy operation. How do I specify that? This is my SQLBulkCopy code.



SqlBulkCopy bcp;

SqlCommand sqlCmd = new SqlCommand();

sqlCmd.Connection = m_dbFiles.conMain;

bcp = new SqlBulkCopy(sqlCmd.Connection);

bcp.DestinationTableName = "tblMyTable";

bcp.WriteToServer(datatable);