Hey Roy! Great article.
What happens if a stored procedure is called with the schema qualifier, BUT inside the stored procedure calls to tables aren't schema qualified?
ie.
CREATE PROC dbo.TEST1 As
select * from Table1 INNER JOIN TABLE2 on Table1.Column1 = Table2.Column1
GO
execute dbo.TEST1
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes