another table corruption question

sql2k sp3
Is there a way to just narrow down the rows of data that are corrupted and
delete them as opposed to the other alternatives? (Restore, CheckTable with
Repair%, etc.)
TIA, ChrisR.There are many types of corruption. The page could be bad. So it is not
always possible to delete the bad row.
--
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"ChrisR" <noemail@.bla.com> wrote in message
news:eDCAX%23nSFHA.576@.TK2MSFTNGP15.phx.gbl...
> sql2k sp3
> Is there a way to just narrow down the rows of data that are corrupted and
> delete them as opposed to the other alternatives? (Restore, CheckTable
> with Repair%, etc.)
>
> TIA, ChrisR.
>
>

Another easy question

I want to use a trigger (FOR DELETE)
For example

CREATE TRIGGER test ON [Table_1]
FOR DELETE
AS
..... export to a text file someting like this:
Date + TableName + UserName + Record with will be deleted

How can I export a single record to a text file ?

Sorry for my englishWell .. use xp_cmdshell and echo for the same|||Please an example will be usefull for me...|||CREATE TRIGGER test ON MyTable
FOR DELETE
AS
BEGIN
DECLARE @.MyString varchar(255)

SELECT @.MyString=
"ECHO "
+convert(varchar(20), getdate(), 0)
+" MyTable "
+ convert(varchar(10), MyKey)
+ user_name()
+ ">> C:\temp\log.txt"

exec xp_cmdshell @.myString
END

another backup quick question

Hi

What does Backup set expiry do? Apart from mark the set as "Not being allowed to restore", does it delete the file?

cheers

ICW

If you're backing up to tape it sets the date the backup expires so the tape can be overwritten on the next cycle.

I personally recommend you back up to disk, then back up those disk files to tape along with your regular network backup.

Annotations - No Copy, No Undo, No Delete confirmation?

In the Business Intellifgence studio, why can't I copy and paste an annotation, why is there no Delete confirmation, it's very easy to accidentally hit the delete option when you right click, worse still, if you do delete accidentally you can't Edit > Undo ? ..or have I missed something here?OK, i found out I can highlight the text, and use Ctrl+C on the keyboard to copy the text...no undo or delete confirmation is my main issue.

Analysis Services Developer Studio Question

I had an obsolete dimension on my cube.

I delete the dimension, it disappears from the GUI (I can see all the other dimensions in the dimensions panel, but this one correctly disappears), yet when I try to build my project I get errors on this dimension. It's like the dimension was deleted from the GUI but still exists somewhere and is causing problems.

How do I resolve this without rebuilding my cube entirely? How do I delete this dimension completely?Are you sure that dimension is absolete ?
If it is not - error looks correct ...
What error do you receive ?