Viewing 15 posts - 1,066 through 1,080 (of 2,897 total)
You can restore the database under a different name, then apply the transaction log up to the point before the transaction occured. What you do next depends on the complexity...
February 2, 2011 at 9:03 am
Can you run backups to another server or drive on your network ?
February 2, 2011 at 8:03 am
You could create a work table with the column formatted as datetime. Then use SSIS to copy from your current table into the work table. You choose a setting in...
February 1, 2011 at 1:35 pm
You could also explain the actual restore steps you would take, to give a more complete answer.
January 31, 2011 at 8:31 pm
Obvious way is to set identity=yes. Otherwise I think you would have to write code to maintain the values. Maybe there's another way ?
January 28, 2011 at 1:30 pm
Looks ok to me.
Double check it's set to auto increment, and not just set to not allow nulls.
January 28, 2011 at 12:39 pm
Probably you have NULLs in RefVal.Div. Maybe you could add
WHERE RefVal.Div is not NULL
Edit: I was mistakenly thinking 'Div' was a primary key.
January 28, 2011 at 11:56 am
I don't think that will work with the quote around your select. If you remove the quotes, it might work, but if the select returns nothing for some TableB records,...
January 28, 2011 at 11:03 am
If you only want to update certain rows, then use a regular WHERE clause at the end. Otherwise, leave it out to update all rows that satisfy the joins.
January 28, 2011 at 10:36 am
Looks like you have the logic to get TableA description, so can you switch it to an update with: SET B.DESCRIPTION = B.DESCRIPTION + ' ' + T3.DESCRIPTION
January 28, 2011 at 9:38 am
Next time, before you delete records from an important table, back up the table and/or archive the records that will be deleted.
January 28, 2011 at 9:18 am
I don't understand your question.
Do you want to update TableB.description to include TableA ?
Sample data and results would help
January 28, 2011 at 9:13 am
The server doesn't need Excel to do the import. It uses the Excel driver included with SQL.
How did the data get into Excel to start with ?
Is this a one...
January 28, 2011 at 9:08 am
As mentioned, be very careful deleting from production.
- Get approval
- Have solid backups
- Save records to be deleted in another table for quick recovery if needed
- Run delete in a...
January 26, 2011 at 10:35 am
Assuming you have email configured, then recipients is just one of the parameters. BOL has all the specs.
January 26, 2011 at 10:28 am
Viewing 15 posts - 1,066 through 1,080 (of 2,897 total)