Do you have the script please to use sysjobactivity?

I would like to bring all the jobs with their names, steps, and the status, last run time, even if there...

Hi,

One more question:

If I have to roll back to the SP2 according to Microsoft i nave to re-install SQL server 2005 and then restore all system dbs, user...

Hi All,

Has anyone actually tried rolling back to the SP2 after installing SP3.

I tried it on my local PC and it did not work.

According the re article quoted...

Everybody! thank you very much for your help! I was able to do what i needed.

thank you!

Hi,

thank you for your reply

I have over 30 servers that i have to check every day, so i can not go to the backup drives and verify the...

OK everyone!

the problem was my files were not a valid sql backup files.

As soon as i tested it on valid sql backups it worked.

P.S. I believe the...

how about now?

And i think i renamed the files (not the extensions though) because i was testing the other job based on filenames. 🙂

Here is the print screen:

Thank you for your reply!

Nothing gets deleted in both cases regardless date format i am using...

So my question was actually: what format should the date be?

in both cases i get...

Hi guys,

I came up with this code. and it works:)

declare @d as varchar (8)

declare @d1 as varchar (12)

DECLARE @NewFileName VarChar(30)

DECLARE @SQL_Command ...

ok, so should we say that after inatalling SQl server we should not worry about resizing msdb and model bd? leve them with their default size?

thank you

hi, I understand that model is just a template, but wouldn't make more sense to set space allocated to some value, so that the new databases created from this template assume...