Couldn't agree more. I personally haven't written queries using the old syntax for something like 10 years. I had just assumed during all that time, that those people, either...

Sorry about that. This article wrote itself since I just copied & pasted the code. Usually I'd write the code for an article seperately. Again, sorry for the confusion.

It is absolutely the driver. The 8i & 9i drivers both had odd behavior, but after getting the 10g OLEDB driver installed, all of it went away. The data type...

Thanks for the response. We've just started looking into the driver to see if that could help. I've been running 8i. I think some of the developers were running 9i...

After I chased the guy down and hopefully retreived the pocket book, I'd try to educate the dope.

One thought that hadn't occurred to me previously, what happens when some other...

I'm an assistant instructor on self-defense and one of the principal things taught to avoid crime is situation awareness. The main problem with having your nose stuck in a computer screen,...

Hmmm... That honestly sounds like a security problem, but its hard to know. Sorry I wasn't much help.

Why not create a SQL Agent job and then run it from sp_start_job?

2gb of memory is the trick. I found the same thing during the beta. My machine last year only had 1gb and it was crashing regularly. I wrote it off...

Being a complete & total history nut, I'd love to get paid for it, so either a school teacher, a professor, or a writer. Lots of time to spend with...

It sounds like you linked up the tasks before you defined the columns to be included. Drop the link between, then set the columns, then reattach the link. It should...

Sorry to say, I'm stumped. I tried replicating it, but I got it seemed to work. I'm just not sure what I'm missing. Sorry.

I haven't done it myself, yet, but it is possible to add a recordset as a variable and then you can pass it around as needed. Here's one article on...

I'd do it in two steps. First, do an update on records where the keys match. Then do a left join with an insert to records where the keys don't...

Oh. That's a bit different. Hmmm... Have you tried debugging it? Stopping on the step that you're running & verifying that the variables are loaded? How about adding logging to...