Chris Carter-210078 (12/30/2009)
The complete answer should be “It depends”. If you have a case sensitive collation designator you will get:Msg 208, Level 16, State 0, Line 3
Invalid object name '#table1'.
Since the script created a table #Table1 and tries to reference #table1
You're correct but based on what's given then you'll need to set collation to something that will provide with results for this scenario.