GilaMonster (3/3/2013)

---

GilaMonster

Same way you check what any session is waiting for, sys.dm_exec_requests

If you believe that Kill with...

Try executing these queries:

SELECT *

FROM sysmail_mailitems

GO

GO

SELECT *

FROM sysmail_log

GO

SELECT *

FROM sysmail_sentitems

SELECT *

FROM sysmail_allitems

SELECT *

FROM sysmail_event_log

My experience is that it does...

Well that does not work. I get 0% of 0%.

Thank you.

How can you check the progress of a rollback?

ok, thanks Gail.

GilaMonster (3/3/2013)

---

Welsh Corgi (3/3/2013)

---

GilaMonster (3/3/2013)

---

Welsh Corgi (3/3/2013)

---

Most times I've seen that it's been a process that has some external component. DTC, remote procedure call, external access, extended procedure, backup. Killing...

GilaMonster (3/3/2013)

---

Welsh Corgi (3/3/2013)

---

Most times I've seen that it's been a process that has some external component. DTC, remote procedure call, external access, extended procedure, backup. Killing a normal SQL...

The block went away.

I did several searches and btw I did not expect you to search for me. I thought that you might have a favorite.

I like the following.

SELECT

...

I just configured Database Mail on 3 Servers on Friday. Make sure the login you use for the account does not expire.

To clean up I would do the following:

USE msdb

GO

DECLARE...

GilaMonster (3/3/2013)

---

Welsh Corgi (3/3/2013)

---

I have blocking going on between 2 different developers.

The blocking has been going on for nearly an hour.

I would have thought that there would have been a...

I have blocking going on between 2 different developers.

The blocking has been going on for nearly an hour.

I would have thought that there would have been a deadlock victim by...

The blocking that occurred happened yesterday was from a Statement that was Deleting from a Table using a Subquery.

This query was placing Exclusive Table Locks.

on two tables.

The Transaction Log was...

I would save the package and then create a solution and add the package to the solution.

Then you may edit the code page.

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/8f0d2a85-1c66-4498-a04f-9353ad1dba03.

Saving the package and running it should provide...

I'm using Windows Server 2008 and I believe that it is Powershell 2.0.

I'm open to various options.

Thanks.