Yes, the hex is 32 + 2 for 0x. Its the uniqueidentifier converted in binary format.

Here you go.

declare @jobid varchar(1000)

Declare curtemp cursor for SELECT SUBSTRING (

PROGRAM_NAME ,

PATINDEX ('%(Job %', PROGRAM_nAME)+ 5,

34)

FROM MASTER..SYSPROCESSES WHERE PROGRAM_NAME LIKE '%STEP%'

open curtemp

fetch next from curtemp...

The hex is the job_id. Try the below

select * from msdb..sysjobs where job_id =

0x3E31DB24ED72CD49A8114462A66A0367

You can use dbcc inputbuffer (spid) for SQL 2000.

The hex is the job_id for the job. You can query sysjobs and it will give you the name of the job.

e.g.

select * from msdb..sysjobs

where job_id = 0x1292021D3C929A4CBBE3895A61FA68CC

You can set snapshot at the database level. This below will change the default of READ_COMMITED TO READ_COMMITED_SNAPSHOT.

ALTER DATABASE MyDatabase

SET READ_COMMITTED_SNAPSHOT ON

More info below.

http://msdn.microsoft.com/en-us/library/tcbchxcb.aspx

RAID 5 is striping with parity.The one disk which Ellis is referencing will be your parity disk. Say if one disk fails. in that scenario, your data will be read...

You can query msdb..backupset for information about what table has bene backed up when.

select Database_Name, Physical_Device_name, Case When type = 'D' then 'Full'

When type = 'L' Then 'log'

When type...

Thanks Jeff for your detetailed response. That is definetely helpful.

Thanks bill, i agree that instances would be a better measure.

You might want to make sure that the disk are on different controllers. and also how many HBA's do you have. We have HBA's with a throughput of 100 mb/S...

Jeff,

How about creating a job without a schedule for the DTS and then start the job from within the procedure ?

Do you have anything else running on the server like OFM(Open File manager) or  any Network intrusion detection softwares 

Kind of dumb But did any Permissions change on the server or domain.

Thanks Andy. I thought there would had been an easy way out. But thanks for the help.