Hello. Through something called the MSDN Academic Alliance (MSDNAA), I installed what what they told me was going to be SQL Server 2005 Developer Edition. However, using the shared directory on their server, the installation program read "Enterprise Edition." Using a method found at KB article 321185, "How to identify your SQL Server version and edition," I finally figured out that I was using 9.00.1399.06/RTM/Express Edition.
Express Edition? The downloadable file at Microsoft is 55MB. My installation is over 500MB. Is there any way I can quickly check whether I have the Enterprise Edition? I have a feeling something in the installation was warped.
Example: How can I quickly do something that requires FULL-TEXT SEARCH?
Thanks.
Alex
If you do a select @.@. version it will tell your the SKU that you have installed.
Michelle
|||Hello. Where would you do this? I did the following,
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
...under New Query and ran it. It gives me EXPRESS EDITION. Where would you type in your line -- and what exactly is it you want me to type?
Thanks!
Alex
|||Can someone answer my question precisely, please? I really need this to get started. If it is the Express Edition I am working with, I have to uninstall and return the product; if the 500+ MB sitting in the directory are in fact the Enterprise Edition, then I can get to work.
|||Yes the query you ran works fine. The alternative method is In a tsql window when you are connected to the server you would exectue "select @.@.version" which also gives you all the properties back in one string.
Yes you have Express Edition installed.
sql