Posts Tagged ‘Service PAck’
Resolving SQL Server 2005 SP3 Installation Problem
Posted by: Manpreet Singh on: July 14, 2009
Have you encountered a problem due to deletion of the contents of C:\Windows\Installer folder? Several times the administrators delete the contents of this folder to make the space free without knowing the consequences. All the previous installation files get stored to this folder specifically the update\patches files which comes in to use when we upgrade the [...]
Finding version of service pack installed on SQL server
Posted by: Manpreet Singh on: August 28, 2008
There are times when we have to look for service pack installed on SQL Server Database Servers. SQL server provides us with many different ways to check service pack installed. Some of most commonly used methods are given below
1). @@version
Using @@version we can see information about SQL server installed on machine
The syntext are
Print [...]
