• T-SQL is required to create the snapshot, but how many people create snapshots using jobs or SSIS packages? Most people open up SSMS to do it, ergo, the common perception (despite the Microsoft article) is that SSMS does support Snapshots because you have to use a query window to do it.

    It seems to me that this question is that it was picked out of a Microsoft article without the author understanding what that comment from the KB article meant. I say this because the author didn't bother to add additional explanation. Just "Look at Microsoft's KB article." Microsoft has posted numerous KB articles, books, and other items with erroneous information before. Most people know this. Therefore, relying on one KB to state the case is a little like a lawyer going into court and saying "You need to rule in my favor because I read a book." to the judge.

    If the author had provided a more complete explanation for this question, aside from the KB article, I would feel like this was less of an attempt to one-up people and more of an honest quiz question.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.