var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: need to find all jobs using sa pwd in it.
I need to know if there is any way to extract all our jobs/dts packages
where the 'sa' password is being used in either the job steps or any stored proc the sa pwd harcoded in it.
for stored procedures/functions, you can search 'sa' from routine_definition in INFORMATION_SCHEMA.ROUTINES view and jobs/DTSs I m sorry at the moment
Originally Posted by ranjandba
Change the sa password and see what jobs come to a screeching halt.
jobs are stored in msdb.
you can search for "sa" or "thesapassword" in the result set returned by msdb.dbo.sp_help_jobstep