Creating test2 db wasn't in the case description, so I didn't. So the SQL message correctly reflects this.

I executed the code against a 2008 server and a 2005 server and got this message both times:

[font="Courier New"]Msg 911, Level 16, State 1, Line 1

Database 'test2' does not exist....

http://msdn.microsoft.com/en-us/library/ms190677.aspx is clear enough on the subject, but I went with the info on http://msdn.microsoft.com/en-us/library/cc645993.aspx: "Database snapshots, introduced in SQL Server 2005, are available only in the Enterprise editions of...

Thank you for your replies.

I may be exposing my ignorance, but is this applicable to SQL server 2008 R2 only?

I get this result in earlier versions of SQL Server:

Invalid object name 'sys.dm_os_memory_nodes'.