Viewing 5 posts - 1 through 5 (of 5 total)
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
January 14, 2013 at 9:15 pm
#1577140
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).
Ben:-D
March 22, 2010 at 12:27 am
#1137425
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...
March 16, 2010 at 6:17 pm
#1134935
Shubhajyoti Ghosh (2/22/2010)
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...
February 23, 2010 at 12:04 am
#1123445
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...
February 22, 2010 at 10:18 pm
#1123418