January 22, 2008 at 11:18 pm
what are some of the ways to find out which service pack is installed on your server? Mostly I use select @@version
Thanks
January 22, 2008 at 11:24 pm
select serverproperty('productlevel')
check BOL
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 24, 2008 at 12:46 am
More details on identifying SQL server version: http://support.microsoft.com/kb/321185
January 24, 2008 at 6:31 am
Ziljan4,
I typically just don't want the SQL Server version. I use this script:
-- Show information about all SQL Server Databases in a given instance.
-- SQL Server 2000
-- SQL Server 2005
USE master
GO
select
-- getdate() as 'Time_Data_Gathered'
--,
cast(serverproperty('ServerName') as varchar(20)) as [Server Name]
,case when serverproperty('InstanceName') is null
then '(default)'
else serverproperty('InstanceName')
end as [Instance Name]
,name as [Database Name]
,cast(serverproperty('productversion') as varchar(20)) as [Product Version]
,cast(serverproperty('productlevel') as varchar(20)) as [Product Level]
,cast(serverproperty('edition') as varchar(40)) as [Edition]
FROM dbo.sysdatabases
Feel free to use it or to modify it to suit your needs.
Happy T-SQLing
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply