Reading Registry value using T-SQL

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... ......

Posted On Thursday, September 8, 2011 9:52 AM

Sql Server: Table row count b4 a blink complete.

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... ......

Posted On Friday, January 28, 2011 4:38 PM