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.

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>