• I selected A as the answer:

    1 (A).

    Schema1    Table1dbo        Table1
    My coworker suggested B as the answer but I know he was wrong.
    Having read and reviewed scheme, it was all good.  Then I saw 
    Answer C, that almost seem right to me because I haven't encounter
    sys.objects before and just last night, I got the information I want 
    from sysobjects ... I was sooo leaning towards C but select B to claim my coworker down.
    What do you know, my answer was right.  He was still questioning the concept so we ran the code
    in sql 2005 and boom, A, was the correct answer.

    -----------------------------
    www.cbtr.net
    .: SQL Backup Admin Tool[/url] :.