Thanks for an interesting question. I got the right answer but not by thinking it all the way through so I learned something new - always a good way...

I was able to look this up and find the right answer but I'd be lying if I said that I understood what is going on here. Is there...

Thanks for the response!

"Database snapshots, introduced in SQL Server 2005, are available only in the Enterprise editions of SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2." from http://msdn.microsoft.com/en-us/library/ms190677.aspx...

Except that they put NO on top and YES on bottom, which could be interpreted as a trick...:-D

jadsmith (5/6/2011)

---

It would depend on if the database backed up contains Enterprise features or not. If not the backup should restore with no problems. The question doesn't say that there...

The only time I remember being involved in an incorrect question/answer issue for the QOTD, no email goes out to anyone. I only saw a post on the associated discussion...

The really sad thing is that this is not all that uncommon an occurrence but if any of the questions are corrected and/or the persons with the actual correct answers...

Thanks! This post (with the edit) answered my question regarding why this was done in such an unnecessarily (in my original opinion) difficult fashion.

Thanks, I must have skipped something. At work now, will try again later. Thanks again!

Can someone verify for me that this is different in SQL 2008 vs SQL 2005? I get a different result using 2005 (I don't have access to a 2008...

Ditto and...

Ditto to the edit, as well.

You can find a pretty good discussion of this issue at this link: http://www.databasejournal.com/features/mssql/article.php/3516331

I hope this helps to solve your problem!

It returned an error when I duplicated the conditions of the question, stating that there was no Sheet1$ object.

There's nothing commented out in the question that I saw.  I understand that the @tablename1 variable is not initialized (no SET statement) but I don't understand why the answer says...