select * from msdb.dbo.sysjobs j
join msdb.dbo.sysjobsteps js on js.job_id = j.job_id
where command like '%reporting_drop_ship_orders%'
select lower(CONVERT(VARCHAR(32), HashBytes('MD5', 'email@address.com'), 2))
When creating a data source with temp tables avoid temp table errors.
"Invalid object name #"
You can add the following lines to your query or procedure.
SET FMTONLY OFF
SET NOCOUNT ON
This will prevent formatting and count errors.
