SQL_path (8/27/2012)
GSquared (8/24/2012)
Same as any other table.and should i drop the ## table in sp2 and sp3 both?
Generally the good practice is to drop objects within the same procedure where they've been created.
Of course, there are exclusions to every rule.
_____________
Code for TallyGenerator