Question: How can I tell which Service Pack is installed on my SQL Server?

Answer: The ServicePack that is installed can be recognized in the SQLServer version number.