Help me find my SQL version! - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Help me find my SQL version!

Author

Topic

anxiouslife
Starting Member

4 Posts

Posted - 2014-06-02 : 18:52:32

I am completely new to SQL and only wish to find my SQL version.

I looked at a few online guides and they instructed to check via the SQL server configuration manager. Sadly, I couldn't find one within windows. The only clue I have as to which version I have is by looking at the list of programs in Control Panel, which shows "Microsoft SQL Server 2005 Compact Edition".

Can someone tell me how to properly find my SQL version?

nagino
Yak Posting Veteran

75 Posts

Posted - 2014-06-02 : 19:42:07

You installed "SQL Server 2005 Compact Edition", file base database.
see also http://en.wikipedia.org/wiki/SQL_Server_Compact

"SQL Server Configuration Manager" use with Server Version.
http://en.wikipedia.org/wiki/Microsoft_SQL_Server

-------------------------------------
From Japan
Sorry, my English ability is limited.

anxiouslife
Starting Member

4 Posts

Posted - 2014-06-02 : 19:55:53

Ok. So how come I can't open the configuration tool??

nagino
Yak Posting Veteran

75 Posts

Posted - 2014-06-02 : 21:26:09

You did not install the configuration tool.
After install Server Version, you can open the configuration tool.
Install Express Edition.
http://www.microsoft.com/en-US/download/details.aspx?id=29062

-------------------------------------
From Japan
Sorry, my English ability is limited.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-06-03 : 01:36:07

Three differents of getting the SQL Server version are - @@version, xp_msver, and SERVERPROPERTY('ProductVersion') - more details on : http://www.sqlserver-dba.com/2012/08/sql-server-get-sql-server-version.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

prett
Posting Yak Master

212 Posts

Posted - 2014-06-03 : 04:26:59

You can check SQL server version details by using either 'Enterprise Manager' or 'SQL Server Management Studi' and right clicking on the instance name and selecting properties.

Read full article: http://www.mssqltips.com/sqlservertip/1140/how-to-tell-what-sql-server-version-you-are-running/

anxiouslife
Starting Member

4 Posts

Posted - 2014-06-12 : 07:27:42

Guys, I can't find Enterprise Manager or SQL Server Management Studio anywhere on my computer?? How do I open it?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2014-06-12 : 07:42:35

"...you want to know the version you are having. There are multiple means:
Registry: HKLM\Software\Microsoft\Microsoft SQL Server Compact Edition\*\DesktopRuntimeVersion
File Properties: Check file properties of some SQL CE DLL and check for "File version" the first line of version tab"

see here:
http://blogs.msdn.com/b/sqlservercompact/archive/2008/02/08/sql-server-compact-release-versions.aspx

Too old to Rock'n'Roll too young to die.

anxiouslife
Starting Member

4 Posts

Posted - 2014-06-12 : 08:57:27

I went into my Registry but I can only see a folder called MSSQL Server?? Can't seem to find DesktopRuntimeVersion

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-06-13 : 00:42:54

@anxiouslife - if you can't find sqlserver management studio - then install the client tools , which inlcudes SSMS.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources