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...

The way you've got it typed up above, it looks like you're trying to parse the string directly in the SQLStatement. That doesn't work. You either have to use the...

You may want to take a look at some of the options outlined here. It shows how to use parameters in the query. Of course, if you really just...

For quick info, searches on Yahoo (used to be Google). For slightly longer research times, books, postings here, blogs.  For even longer term learning, books & conferences.

Microsoft actually publishes...

I'm beginning to the think the software has failed. I can't seem to post a reply to this topic properly.

The error is in how the proc is called. If you...

I found the difference. I'm calling the procedure differently. You're using the TSQL standard of '? = EXEC proc' instead of '{? = CALL proc}'

I found out why that's a...

Just change the name of the parameter to '0' (no quotes).

Check here from the BOL:http://msdn2.microsoft.com/en-us/library/ms141003.aspx

That was an outstanding article. Thanks.

We're currently in a bit of a struggle with a development team that has become completely enamored with generated code. Problem is, with type of...