I don't think Jacob is the one suffering from a lack of knowledge, Sergiy. What happens when two different users simultaneously call the same stored procedure? Kaboom, that's what happens....

Interesting. But unfortunately not very useful for us; we're a SQL Server 2005 shop and Microsoft has warned in no uncertain terms that extended stored procedure support is going away....