Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Binoyvv
Starting Member
2 Posts |
 Posted - 2009-05-25 : 07:50:21
|
| Hi,Any one knows how to find out the difference between Enterprise and Standard version by seeing the file size (e.g. SQLSERVR.EXE file size) of the install?I know article http://support.microsoft.com/kb/321185 tell "How to identify your SQL Server version and edition?".But I want to find out the edition by searching for a particular file in the install directory and that file should tell which edition the SQL installed is.... Can any one please help on this?Thanks Binoy |
|
|
nduggan23
Starting Member
42 Posts |
Posted - 2009-05-25 : 09:01:47
|
| you could check the registry. it will tell you the version installed. dont know if you can tell by looking at a file. as the difference between developer and enterprise is just the license. |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-05-25 : 09:35:17
|
| You can probably right click it - go to properties then version tab.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
Binoyvv
Starting Member
2 Posts |
Posted - 2009-05-25 : 10:55:41
|
| Thanks Charlie... Yes, right click - properties will tell the version of that SQL. But is there any way to find out which edition the SQL (Enterprise, Standard or Develper) install is?If we compare the Enterprise and Standard installs, do you know any additional files Enterprise edition installs? Or do you know whether SQLSERVR.EXE varies with Enterprise and Standard editions?Thanks for your help..... |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-05-26 : 05:08:26
|
| I'm sorry -- I don't know and I have no way to compare. We only have the standard edition here.Charlie.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
Difference between Enterprise and Standard Version