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

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.

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.

For know this you have the system requirement for running the SQL program sp1 or sp2. Server management.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions