Solved

What version and type of sql server do i have installed?

Posted on 2011-03-08
3
3,154 Views
Last Modified: 2012-05-11
Hi, I'm running windows 7 Enterprise.  The current sql express version information is as below.  I'm not sure if it's 64 bit or not.  I believe it's sql 2005 and maybe it's express and 64 bit but I'm not sure.  Can any one tell by looking at these inforamtion.  Also, attached is a screen shot of the Programs installed.  thanks.
 
Microsoft SQL Server Management Studio                                    9.00.5000.00
Microsoft Analysis Services Client Tools                                    2005.090.5000.00
Microsoft Data Access Components (MDAC)                                    6.1.7600.16385 (win7_rtm.090713-1255)
Microsoft MSXML                                    3.0 5.0 6.0
Microsoft Internet Explorer                                    8.0.7600.16385
Microsoft .NET Framework                                    2.0.50727.4952
Operating System                                    6.1.7600

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)   Feb  9 2007 22:47:07   Copyright (c) 1988-2005 Microsoft Corporation  Express Edition on Windows NT 6.1 (Build 7600: )
progInstalled.jpg
0
Comment
Question by:lapucca
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 15

Accepted Solution

by:
derekkromm earned 500 total points
ID: 35071874
sql server express 2005 32-bit
0
 

Author Closing Comment

by:lapucca
ID: 35072056
thank you.
0
 
LVL 1

Expert Comment

by:sanjaykhed
ID: 35891234
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)  this shows 32-bit
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question