Thanks Guys,

Mostly SFTP and FTP.

Does it provide a log of all the transfers?

THanks,

Nish

Thanks Guys,

Im looking into it now...

Its fine i sorted it out..

update yyyy

set TGI_CLUSTER_CODE = case

when CLUSTER_CODE in ('1M' , '2M' , '3M' ,...

Thanks Guys,

Much Appreciated.:)

Hi There,

here is the code.

Thanks

use msdb

go

declare

@job_idvarchar (100),

@namevarchar(100),

@Step_IDvarchar(25),

@Start_Step_IDvarchar(25),

@Step_Namevarchar(100),

@Last_Run_Durationvarchar(25),

@Last_Run_Datevarchar(25),

@Last_Run_Timevarchar(25),

@Next_Run_Datevarchar(25),

@Next_Run_Timevarchar(25),

@Supportvarchar(25),

@messagevarchar(8000)

declare ND_Cur cursor for

select distinct j.job_id,

j.name as Name,

j.start_step_id as Start_Step_ID,

jst.step_id as Step_ID,

jst.step_name as Step_Name,

jst.last_run_duration as Last_Run_Duration,

convert(varchar(10),jst.last_run_date,...

Thank You

I will have a look at it,

I Really Appreciate It.

😀

Thanks Guys,

im testing the WMI Event Alert,

will let you know how it goes.

Hey thank for the Replies Guys,

I am using the EXEC sp_change_users_login 'Report'

[Is...

Hey Thanks

I Have found that sp_sp_validatelogins don't work very well,

but i did find that this works quite well...

USE [DBName]

go

sp_change_users_login @Action='Report'

go

if you come across anything that might help please share with...

Sorry its my first time and i think i posted it in the wring place.

Thanx Markus

I have used profiler to write to a table, and it works fine,

i just need to setup jobs to start up the process after the backup and restore. and...

are you willing to accept a DBA from South Africa??