January 14, 2019 at 9:47 am
Hi All,
I am trying to gather some SQL server version and OS lvl information and thinking what is the best way to do it since I have more than 10 servers.
1. How can I get the OS and SQL server current patch level information? is it select @@version? or do we have better options?
2. What should be the right patch level, How do you know if this patch is outdated. Is it I have to go Microsoft site or just google?
Trying to learn the best approach for simple work task. Please share your advise.
Have a wonderful day!
January 14, 2019 at 11:58 am
1. How can I get the OS and SQL server current patch level information? is it select @@version? or do we have better options?
you may register all your boxes in management studio and run below statements against them.
select @@version
go
exec sp_configure 'xp_cmdshell',1
go
reconfigure
go
exec xp_cmdshell 'systeminfo'
go
exec sp_configure 'xp_cmdshell',0
go
reconfigure
go
2. What should be the right patch level, How do you know if this patch is outdated. Is it I have to go Microsoft site or just google?
use windows update and or windows update manager
https://www.microsoft.com/en-us/p/update-manager-for-windows/9nkxc6zq5r94
January 14, 2019 at 12:01 pm
??
January 14, 2019 at 1:00 pm
see above
January 14, 2019 at 1:04 pm
Thanks
January 15, 2019 at 7:21 am
Here is a great reference for SQL Server builds.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply