Thanks for the info. I'll try that. Have a great day!

Well good grief, that was the problem! Kinda misleading error message! Thanks.

Thanks. I'm all set.

Hmm... now when I try to insert a record, I get this:

Msg 50000, Level 16, State 2, Procedure PEC_Jobs, Line 1676

Error 515 "Cannot insert the value NULL into column 'run_id',...

I was able to change the key to an Identity key, retaining my numbers, by using the designer. Kewl.

Well, even with the OUTPUT statement, I'm still having a timing issue. I think I need to do this as an Identity column. The problem is that I have...

Thanks!

Okay, thanks. And I guess this new article here on SSC might be of help as well:

http://www.sqlservercentral.com/blogs/chadmiller/archive/2010/12/25/pbm-and-powershell.aspx

Happy New Year everybody.

Thank you for the helpful response. Unfortunately, MSDN blogs have some screwy relationship with Live ID that makes it impossible for me to log in, even though I have two...

I had a software business for about 18 years. A couple of years ago it dried up. Fortunately I had a customer for 16 years and they hired me on,...

Okay. Point taken.

Have a great day.

Sorry. It was such a silly error it hardly seemed worth it. Is there any way to delete a post?

In other words, comment out the WITH line and it works.

Comment out the CREATE line and it doesn't.

Thanks for the responses.

But this doesn't resolve the issue. I am providing the script so you can compare the results in SSMS...

See the Create statement and the With statement...

Works like a charm. Many thanks. I think I finally have an elegant solution for duplicates.