There was a post that hit the nail on the head. Your where clause that stipulates that RAT_FILENAME IS NOT NULL does not limit results due to there being...

If you check BOL for CREATE PROCEDURE you will find it...

You could use it for test isolation. Say you are upgrading a procedure that is used in a few...

Here is another illastration of a solution for your consideration;

EXECUTE sp_MSforeachtable 'PRINT Object_Name(Object_ID(''?''))'

Or you could use a substatute char in the string. There are obvious disadvantages with this, but there is a lot less string concantination and that is a good...

You could also look at QuoteName()

DECLARE @quote Char(1)

SET @quote = ''''

PRINT 'WHERE LastName = ' + QuoteName( @LName, @quote )

PRINT 'WHERE TDate = ' + QuoteName(...