Koen Verbeeck (7/31/2014)
SQLRNNR (7/30/2014)
Good Question.I do think the answer is a dead give away if you have familiarity with sys.objects though.
+1. Dead easy once you know which column you need.
Still nice question.
Agreed, but a good question that may spark learning if you don't know system tables. I think sys.objects is probably the best place to start.