I tend to agree with Grant. It does look like some type of corruption or issue with the Agent DLLs.

Why copy it? Is the logic that complex?

Couldn't you copy the row back into the table directly, changing the columns?

insert TableA

select ColA+1

...

My vote would be to do what you want. Do you like being a DBA? Is there something in SQL Server that interests you? I know that as you move...

GilaMonster (5/6/2010)

Um.....

MVP status is not something that you should be 'going for' as a career goal....

I use Password Safe. It isn't multi-user per se, but you can open multiple copies and it will say that you can open read only or read-write.

Password Safe[/url]

I have seen...

I might agree with Dan here. Can you drop the plan, or all plans and see if the plan changes? If not, I'd suggest starting a new thread, and posting...

I think that David's and Wayne's...

The only way I think this is beneficial is that if you are covering a query with the NC, then it is less IO to seek to values in the...

Not a bad thing, but for those of you that are MVPs, keep that in mind when reporting. I tend to report about 3/4 of my posts to MVPs noting...

I'd separate them. I've dealt with this before and when someone rewrite the rules slightly, or you merge companies, move people, etc. it's painful.

I'd learn towards separate tables for the...

Top Ten Posters in this thread (out of 15,100 or so)

Lynn Pettis 1533

CirquedeSQLeil ...

Congrats, Grant. I wonder how many of those are in this thread. Hmmmm, maybe I should do a touch of analysis 🙂

If this is important, and it's worth money to your business to avoid data loss, or much data loss, hire someone. Building a DR solution is something that takes some...

The issues are likely complaints about slow performance. The resolution is to hire someone to help you.

Excellent! I'm going...