17 People are following this question.
Execute Permission to Particular Stored Procedure or Function in All databases of a SQL Server 2008 Instance
Nested Transactions in the stored proc
matching string of one table to substring of another table
Using outer query tables in sub-query joins (defined in select clause)