Tag: "version"

SQL Server Information

Feb 20th

Posted by tosc in SQL Server

4 comments

Only a short script to get informations about your SQL Server enviroment, like machine name, instance name, edition, version, level, cluster security, user mode, collation and login. I use it as a piece on my whole admin scripts. --> SQL… more »
sql server, sysadmin, version

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

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