Well, I would use SQL Server Profiler to setup the trace. I'd filter on the database name (msdb) and include events that have to with locking/blocking and the...

Man that really sucks Jeff. I was looking forward to meeting you. You were on my list. I even made it public.

Lynn Pettis (10/26/2009)

---

I'll second...

Thanks Bob. I figured there was a good reason Flo was not posting, but I didn't remember hearing anything.

Bob Hovious 24601 (10/26/2009)

---

If it's any help, I always think of him as "Crawfish" (yes, I know it's Crawford). 😉

Good to see you back posting in the main forums, Jack....

ahperez (10/26/2009)

---

Not generally a talker on topics, but while I find SSC very useful, I don't find use for PASS at all. I can't use my scant training dollars to...

G,

I don't see anything in the error message that really helps me. I know when I have had issues it has usually been caused by AV. Does the...

1. In my opinion DBA and BI are pretty different so you are likely to go one path or the other. BI is more marketable right now, but...

Sure, there will be locks on the table being inserted into while the insert happens. Depending on the indexes and some other factors the type of lock will vary...

You should be able to do view definition to the schema(s).

First question,

What has changed?

Did you do a CU or service pack either SQL or Windows?

Is Anti-virus on the server? Did it get an update?

Did anything...

What account did you give the permission to? I'd guess that the package is running under the IIS credentials at this pount.

If you put a partition by on your the row_number function it will return the same row_number for the same dates, assuming you don't store the time portion of the...

Be sure to check Anti-virus. I have a blog post about this, http://wiseman-wiseguy.blogspot.com/2009/07/mystery-of-failing-database-mail.html. Different error message, but worth a look.

I suggest you start here. Then come back with specific questions.