Tag: "version"
SQL Server Information
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 »
4 comments »
Which service pack do I have installed?
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 »
