Ask questions via twitter! Message any question to @answers on twitter. We'll publish the question and send you a reply each time there's a new answer.
Next Question

Answered Question

santu123 santu123
 
January 12, 2009 11:59 AM

Before installing my application, I want to check whether the system is having sql server 2005 sp1/ sp2

my application requires sql server 2005 sp2, or atleast sql server 2005 sp1
other wise i will install an exe("SQLEXPR_ADV.EXE"), which I have, to run my application successfully.
can you help to check whether the system is having sql server 2005 sp1 or sql server 2005 sp2.
my email id is "santuyours@gmail.com" dont forgot to mail me.
Interesting Question?  Yes (0)   No (0)   
RSS
 
 

Best Answer  Chosen by Asker

eortiz eortiz
 
 January 14, 2009 01:45 AM
If what is left to know is the SQL server version, there's a KB article on the microsoft support site that explains how to get the version installed, on SQL server 2005 the query for this is the following:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
The following table lists the Sqlservr.exe version number:
Release Sqlservr.exe
RTM 2005.90.1399
SQL Server 2005 Service Pack 1 2005.90.2047
SQL Server 2005 Service Pack 2 2005.90.3042
SQL Server 2005 Service Pack 3 2005.90.4035
Source(s):
http://support.microsoft.com/kb/321185



Helpful Answer?  (0)   (0)    Tip eortiz for this answer
Permalink | Report
   Reply  
 
 

Other Answers (1)

Sort By
jpryor jpryor
 
January 12, 2009 01:59 PM
Just try running a simple command line query. The script below will display all the databases on your system. Just change the part that says "-Myservername" to the name of your computer (or IP address). OSQL is the command line interface to SQL Server. If you get an error like: 'osql' is not recognized... then you know you do not have SQL installed.

OSQL -E -Myservername -Q"SELECT name FROM sysdatabases"

Helpful Answer?  (1)   (0)    Tip jpryor for this answer
Permalink | Report
   Reply  
 
 
santu123 santu123
 
January 13, 2009 11:42 AM
my appliation requirement at least sql server 2005 sp1, if it has sql server 2005 with sp2, it is more enough, if it has only sql server 2005, then we need to install sp1. if system doesn't have sql server 2005 at all, then we are installing sql express demo version i.e "SQLEXPR_ADV.EXE" (which is also suitable for our application). But I wants to check whether sql server databse is installed, if is not sql server 2005, or sql server 2005 sp1, or sql server 2005 sp2, I need to have "SQLEXPR_ADV.EXE". the minimal requirement is sql server 2005 with sp1.

Report
 
 

Answer this Question

How tips and payments work

This question has already been resolved. You may add an answer to it but you will not be eligible to win best answer or any associated tips.

Related Questions

View All Web Development Questions

Ask a Question


140 characters left
Top of Page
Buy Mahalo Dollars with Credit Card or PayPal

Top Members

This Week All Time
  • buddawiggi
    buddawiggi
    2nd Degree Black Belt
    28397 Points
    M$815.66 Earned
  • cfinke
    cfinke
    2nd Degree Black Belt
    26457 Points
    M$29.75 Earned
  • thisjustme
    thisjustme
    Green Belt
    1132 Points
    M$76.05 Earned
   See All
 

Most Popular Tags

mahalo(1719)
twitter(966)
music(489)
iphone(479)
google(375)
food(332)
online(328)
internet(309)
beer(282)
money(278)
movies(275)
apple(256)
facebook(248)
answers(235)
aotd(235)
health(226)
video(219)
free(216)
dog(209)
windows(202)
   See All
 

Categories

Welcome New Members


 
 
Mahalo Dollars are the currency of Mahalo Answers.

Each Mahalo Dollar costs $1.

Once you earn more than 40 Mahalo Dollars, you can request to be paid via PayPal. Each Mahalo Dollar is currently worth $0.75 when paid out via PayPal. Learn More

 
 

Please log in to use this function.

Answers Home | Ask a Question | Earn Points | How Tips Work | Widget