How to tell difference between sql 2005 and express edition

Here’s a useful tip i was wondering what version of sql was installed on a server if it was the standard or express edition, open the management studio and click new query type

select @@version

and execute it it should bring up a dialog box with what version you are running.

[…]