Not quite.  They backup file that you have is a SQL Server backup.  The physical file names you see in the options tab are the physical Data and Log file...

No, it does not. 

Well, what errors are you getting?  Lemme guess, filenames?  Look in the options tab for the Restore Database As section.  The logical file name and it's physical location will be...

Move the backup file to your backup server and use SQL Enterprise Manager to restore the database.  Are you familiar with EM?  If not, right click on the Databases...

Well, do you want to insert new rows into Document_Image or update existing rows in the table?  This will tell you which type of statement you need to start with,...

What do you mean by 'load'? 

Sameer, scratch my example and go with Peter's.  In my haste to get an example out, I overlooked how simple this one was to eliminate the unwanted rows in the...

In that case, I usually check both @@ERROR and the return value from the stored procedure. 

DECLARE @intReturnValue int

EXEC @intReturnValue = proc_Call_Some_StoredProcedure

SET @intSQLErrorNumber = COALESCE(NULLIF(@intReturnValue,0),@@ERROR,1001)

IF @intSQLErrorNumber <> 0......

You have declared your cursor to be a SELECT *, but your FETCH is only using the e-mail.  Change your cursor declaration to be SELECT email from temp_free2.

P.S. - I...

Sameer,

Here's an example of a derived table used in the OUTER JOIN.  This should work for you, but I have not been able to test it as I do...

The problem is in your SET @GridDude = (SELECT....) section.  All of those SELECTs in your SET statements have the ability to return more than one value.  You cannot assign...

I do a combination of both.  Execution plan is important, but so is logical reads.  Stored procedure performance is subjective.  What are you trying to accomplish?

You are correct.  What you want to do is to assign @sError = @@ERROR and then test for @sError <> 0.

You'll have to recreate them.  Do you have an empty schema DB or a backup of your DB you could look at to see what the indexes were?

A bit more information here would be real helpful.  Can you post the relevent table DDL for all tables involved as well as sample data for each table and an...