Tuesday, August 12, 2008

Perfmon: "Unable to connect to machine"

1) grant Local Service full control permissions on HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows
NT\CurrentVersion\Perflib
2) Start Remote Registry service

Friday, August 1, 2008

SQL: retrieve store procedures definitions in SQL Server

select P.name, M.definition
from sys.sql_modules M
inner join sys.procedures P
on P.object_id = M.object_id
order by P.name