DECLARE @RegLoc VARCHAR(100) select @RegLoc='SOFTWARE\Microsoft... NT\CurrentVersion' EXEC [master].[dbo].[xp_regread] @rootkey='HKEY_LOCAL_MACHINE', @key=@RegLoc, @value_name='ProductName' The above code will return the installed version of windows on which the current instance of Sql Server is running. references: http://www.mssqlcity.com/Ar... ......
Its always time consuming when ever we have to get the row count on the table that includes millions of rows but not any more get the result back b4 an eye complete its blink. EXEC sys.sp_spaceused N'tblename' Replace tablename with the name of your table and see the result. http://www.sqlservercentral... ......