Yes, I tried to send a test mail from database mail, I am getting the above error, as well

If use the sysmail_start_sp , I didn't get any output ---...

Thanks for the swift response ..... I will ping with Sysadmin..

Thanks, But we need to have the IIS server on SQl server server machine? or else What are the prerequisites for DB mail profiling...

Its very useful for the beginner. If the same sample, if available using SSAS would be great...

Yes, We have a cross validations with 10 Master table then Update and Insertions based on the Logic. from excel one row at a time. as per the client...

Yes, I decided to make as Sp and calling directly from Import tool...

Great Gail! Thanks I will move for the Dynamic query

Thanks I agree, its Blocking issues, Now I would like to know with one scenario;

I have Insertions statement to table (T1) in one SP;

that same Sp...

But its Blocking issue only right? The select statement will be in wait status until the insertion Procedures commit or Rollback

Then why this state is moving to DEAD Lock victims?

THanks for answer, So what will happen or difference between with DBCC FREESESSIONCACHE ,

Yes I can..thanks

Thanks for all valuable feedback... I think first 2000 to 2005 and clearing all the issues then will move to 2012,? but it will take lot of time for single...

What will happen, if 2000 sp's query's likes *= or =* ,

If the problem occurs again, Just save as the Excel sheet as Tab Delimiter Text file then u start to load as Flat File source, That wont give u error,

Thanks for reply,, I have found the problem from Stored Procedure with high query cost,, Just reduced,. now its working fine...