Thanks!

Hi, I'm wondering if it's possible to create a xml structure where one column as the element name, another as the element value and another column as the attribute value?

Hi Utsab,

thanks for your reply.

your assumptions are accurate.

Both the 2K and 2K5 are in Windows and SQL Server authentication mode.

I created a "test" job on the 2K5 box that was...

Hi Utsab,

no, I'm using a SQL Server Account.

I was doing a test earlier on the SQL Server 2005 by creating a job on it. The test job failed, with the...

hi Adil,

thanks for the input. I tried to connect to the linked server as a sa account, the same error happens..

He's the same guy that started the discovery of SONY's rootkit isn't it?

Michael Crichton is my all time favorite. But I don't really like it when I read "The State of Fear". Maybe I was having too much expectation on the book....

I totally agree. All I need from my cellphone is probably the basica call/receive, message and voice mail. The alarm clock and calendar are good-to-have but I can live without....

I think the latter would be the worst. At least you wasted less time reading the one-liners messages. Just my 2 cents:-)

Hi Ray,

thanks for the reply. I think for my case, to control when to execute the procedure will be the easiest to prevent the scenario you mentioned. The job only...

rent-a-coder huh? at least they're paying for the price. That reminds me of my time back in college. Someone in the same class that I don't even know the names...

oops, when I say global variable I actually mean to create a table to store value of the mutex variable.

geez... I didn't think of that scenario! my problem is only a bit simplier though. The procedure is created to run once a week by a job. So the odds...

Just a quick update, I used a get around to solve this problem. Instead of table variable, I use global temp table. So now the bcp command is able to...

does it mean i have no alternative but to create a real table to store those data?