Checking SQL Server Edition Version

While working on this one release, I had to do lots of backup, restore, and scripts for different database server versions. Run this script a lot today. Noted that this script is very handy to check out the server edition and version.

select serverproperty('edition')
select @@version

And another annoying thing I found is that when you script the whole database with schema + data, it generates huge script file which sometimes cannot open in SQL Management Studio and even if the file gets opened, cannot execute it due to not enough memory problem. So found out that I cannot solve the problem of restoring backups on different servers by scripting whole db.