ClustrMap
-
Recent Posts
- Use sp_msforeachdb to change database owner to ‘sa’ account
- Two ways to know the underlying OS version number by T-SQL
- Error: Login failed for user ”. Reason: Server is in single user mode. Only one administrator can connect at this time.
- Two quick tips to improve backup and restore performance from Brent Ozar
- Error: “Cannot generate SSPI context” when connect to a SQL Server instance after service account change
Archives
Categories
Meta
Monthly Archives: July 2011
Two ways to know the underlying OS version number by T-SQL
The very quick one is select @@version. Another way is to take advantage of extended stored procedure xp_msver, for example, exec xp_msver ‘WindowsVersion’.
Posted in T-SQL Script
Leave a comment
