Viewing 15 posts - 2,116 through 2,130 (of 3,232 total)
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...
August 30, 2007 at 3:38 pm
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...
August 30, 2007 at 3:28 pm
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,...
August 30, 2007 at 3:20 pm
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...
August 30, 2007 at 7:57 am
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......
August 30, 2007 at 7:49 am
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...
August 29, 2007 at 3:58 pm
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...
August 29, 2007 at 3:29 pm
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...
August 29, 2007 at 3:21 pm
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?
August 29, 2007 at 12:39 pm
You are correct. What you want to do is to assign @sError = @@ERROR and then test for @sError <> 0.
August 29, 2007 at 12:35 pm
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?
August 29, 2007 at 12:33 pm
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...
August 29, 2007 at 9:09 am
From what I'm gathering here, you're database went down prior to your 2:00 backup running and the last backup that you have is the 1:45 backup. You can only recover...
August 29, 2007 at 9:04 am
Viewing 15 posts - 2,116 through 2,130 (of 3,232 total)