I just solved this issue.

two ways,

1, remote desktop to sql server do bulk insert there.

2, or you can use sql authentication to login.

have fun

Thanks for the quick fix,

I turned on locks

SET (ALLOW_PAGE_LOCKS = ON),

ran my job,

then switched it off again

SET (ALLOW_PAGE_LOCKS = OFF).

have fun

Ben:-D

shannon714 (12/30/2009)

---

/*

sorry if this information is repeated elsewhere in the discussion. I only read through the first three pages of posts earlier.

*/

Newbie,

I had a similar problem where I was...

Shubhajyoti Ghosh (2/22/2010)

---

Hi Ben,

Your recommendation is appreciated, But not always need to delete Temp table explicitly. If someone working as DBA, then he or she have oder option to handle...

Hi all,

Good day.

Shubhajyoti, you need to improve your SQL skills, not waste time to create a sp to delete tables.

if you want to create some tmp tables, you can name...