This:  If @retval = 0 then successfull, else failure. was a comment telling you that if @retval = 0 then the stored procedure executed successfully, else it failed.

Please try taking...

This:  If @retval = 0 then successfull, else failure. was a comment telling you that if @retval = 0 then the stored procedure executed successfully, else it failed.

Please try taking...

declare @retval int

exec @reval = Load_Audit_Excel.Sp_Start_job @Audit = 'Audit Data Load'

select @retval

If @retval = 0 then successfull, else failure.

Try reading BOL, all of this is there.

For us to help you, you need to show us what you have already done, and what you are trying to accomplish.

The login (user) you are logged in has needs to have grant permission on the stored procedure for you to be able to grant permissions to others.  You either need to...

Even if you want to backup to a network server for failover purposes, I would still do the backup to a local drive and then move it seperately.  The backup...

I'm not a network person, but it looks like you have lost connection to the remote server you are trying to backup the database to.  If you have the space,...

Do you need point-in-time recovery of your database or is a single nightly backup good enough for your purposes.  If you don't need point-in-time recovery, change your recovery mode to...

If your database is in Full Recovery Mode, as I assume, just completing a full backup nightly is the reason your transaction log is getting so big.  Full backups and...

Several questions first.  I am assuming that your database(s) are in Full Recovery mode.  What is your current backup strategy?  How often, and what type of backups are you completing? ...

Declare one or more variables to retain the status of @@FETCH_STATUS.  One variable for each cursor, especially if you have nested cursors.  Then capture the status of @@FETCH_STATUS immediately after...

You could replace the 10:00 PM Truncate Log with a delete <Weekday>_Log.BAK prior to the first Transaction Log backup.  As for preparing for EVERYTHING that can go wrong, there is...

Try this:

select substring('2006-zzzz', 1, patindex('%-%', '2006-zzzz') - 1)

You would actually replace the hardcoded string with a variable or column name.

I just reread what you posted regarding your backup process.  To be sure what is going on,

you use the same filename for your transaction log backup file each day.  It...

My concern with your process is this; If you were attempting to restore to 10:00 AM Thursday due to a hardware failure and your Thursday morning Differential Backup file was...