Before installing my application, I want to check whether the system is having sql server 2005 sp1/ sp2
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.
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$3 Answers
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
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$OSQL -E -Myservername -Q"SELECT name FROM sysdatabases"
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
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.
Server management
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
