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


Thank You!
send