Hi,

I have made a little changes in the above code

declare @tblStr varchar(max)

declare @intMnth int

declare @strMnth varchar(10)

set @intMnth =1

while @intmnth <= 12

begin

set @strMnth = case when len(cast(@intmnth as varchar(10))) =...

Hi,

The simple way will be to use SQL server import export wizard.

Right click on your database select TASKS then IMPORT DATA or EXPORT DATA which ever is suitable

and you can...

Hi,

What information do you want

1) Who deleted the job

or

2) The job scripts

If you want the job scripts

You should have the backup of MSDB database. U can restore it...