Sorry to say, I disagree.  It is the DBA's job to make sure that what happened does not.  I suspect that the DBA knew the situation, but chose to take...

check BOL for the system table syslockinfo, it will give you the info on all, but 1,3,6;

1 = Sch-S (Schema stability). Ensures that a schema element, such as a table...

sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
sp_configure 'blocked process threshold', 20 ; -- 20 seconds (or to whatever)
GO
RECONFIGURE
GO
This will force a report to be generated.  

You can also configure alert to...

I think you will have to define used in this case. 

Just a login?  If that is sufficient you could modify server to audit successful logins, but that won't tell...

I suggest that you keep the RI, but not the On Delete or On update.  Handle that through the application. 

"SPID Blocking" as you call it is caused by an operation in an open transaction that has not either commited or rolled back.  This is an application issue.  There is...

I am going to assume you are using the GUI and not doing this by hand.  So, when defining the step, there is a drop down that has the database...

Take out the use, and specify the db as part of the job.  If you look at the error message I bet it is complaining about the USE statement.  FYI: ...

You just don't know when to stop.  Let me put it this way.  If you are under 25, I hope you wise up soon, because this attitude WILL catch up...

Ryan,

It appears that your tone has gone down a notch.  And I think that we all agree that a couple of comments made by you and others were over the...

This works if the function returns a scalar, but not if it returns a table.

cross apply(oops only 2005)  But I'll leave the post.

From BOL

The APPLY operator allows you to invoke a table-valued function for each row returned by an outer table expression of a...

Wouldn't matter

@@ROWCOUNT will always refer to the previous select not the current one.  So given that the name of the column is "BAR" perhaps it is where the person the...

These are max() functions, but same thing.  You may be able to do it, but will it really be more efficient?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=387101#bm389305

It is not that your link won't work.  It will.  However the function has no intelligence about the data.  When you choose to partition data it should have some intelligence...