Tag: "serverproperty"

BgInfo, WMI and SQL Server

Jun 27th

Posted by tosc in SQL Server

3 comments

BgInfo from Sysinternals (now Windows Sysinternals, by Mark Russinovich) automatically displays relevant information about a Windows computer on the desktop's background, such as the computer name, IP address, service pack version, and more interesting… more »
bginfo, script, serverproperty, services, t-sql

Which service pack do I have installed?

Apr 3rd

Posted by tosc in SQL Server

No comments

Related to previous post's, sometimes it is helpful to quickly determine SQL Server's service pack level.By selecting @@VERSION in a query window ...SELECT @@VERSION AS "SQL Server Version"you / I get following result: more »
serverproperty, service pack, sql server, t-sql, version, xp_msver

Tag cloud

backup «best practices» books bug configuration ctp «cumulative update» demo denali dmv ebook humor index indexoptimize integrity kbfix loginproperty maintenance «ms sql server 2008» performance php profiler «reporting services» reviews rtm «service pack» «service pack 2» «service packs» sharepoint «sql 2012» «sql pass» «sql server» «sql server 2005» «sql server 2008 r2» «sql server 2012» «sql server 2014» sqlcat sqlpass «sqlpass franken» ssms ssmstoolspack sysadmin «system views» t-sql «technical note» tempdb tools troubleshooting upgrade whitepapers