Certainly the exec option should only be used if necessary.  Having the SQL "in-line" in the stored procedure enables it to be checked and precompiled and ready to run.  Dynamic...

Re: deleting duplicates.  I mean to delete the duplicates from the temp table after the bulk insert, by performing the join.

DELETE #TempHolder 
  From #TempHolder P INNER join MedicService20060601...

I assumed I knew what would happen, but I thought I would test it anyway.

create table #a (fld1 int)
--create table #b (fld1 varchar(50))
create table #did_it (fld1 varchar(50))
declare @sql nvarchar(50)

begin transaction

set...

Change your char() to varchar(), or trim the variables.  You are trying to concatenate 2 50 character fields into 1 50 character field.  They do concatenate, but with 33 space...

You will not be able to move the log files (or data files) to a network drive.  SQL Server will not support either on network drives.  Only backup files can...

I believe this to be a limitation of debugger, not limitation of CLR.  Only one debugger process can attach to a process.  Peter: you almost right, each process won't interfere...

Not entirely.  I assume you are talking about in stored procedure programming (or trigger, functions, etc)  Depending on the error severity, most errors are actually "ignored", and you need to...

In Query Analyzer, Tools, Options, "Results" tab, check "Scroll results as received".

You might consider using 3rd party backup software like SQL LiteSpeed, that will compress the backup as it gets written.  That gets you faster backup and smaller file, and you won't...

Client Access also has an OLEDB driver, you might try that one.  It has been a little while since I used it, but I remember one was faster, but one...

You have a problem with the connection string ("Invalid connection string attribute"), and it is causing the connection to attempt a Windows Authenticated logon ("Not associated with a trusted SQL...

I'm sure the problem is not the Bulk Insert, but the Insert..Select/join statement.  That statement is joining and inserting 15 million rows in a single transaction!  I suggest that you...

Modify your format file so that the field delimiters includes the quote character, like "," instead of just ,

Hope this helps

This may help.  I think I did something similar to what you are trying to do.  I think you are just trying to return a table with an exploded listing...

First, the basics: The error is that you have exceeded the nested procedure call level of 32.  You have reached 32 levels of recursion for calling GetReports.

I'm not sure what...