I was able to repair the table successfully with repair_with_data_loss without loosing the data, but now when I ran the report it failed again with the same error of Torn Page....

Adam, what should I say... I've been put under friendly pressure by Erland to participate in the private newsgroups. I'll beg my network admins on my knees to open up nntp...

Might be helpful to see what you have done.

Thanks, I know, I'm watching your post count and it's quite impressive. You're more than welcome in this competition!

Lucky me! You are certainly one of the most knowledgeable guys I've come across!

Looking forward for a friendly competition here.

Hehe, according to my internal statistics, I will beat Antares686 (#1 poster) by 20051219 on post count... Way to go here.

Not quite sure, if I understand you, but see if this helps:

http://www.sommarskog.se/dyn-search.html

And in case, that goes your direction, you'd better read this http://www.sommarskog.se/dynamic_sql.html , too. Try to convince your...

Guys, you really, really make me feel ashame. It's me, who's proud to be a part of this community!!!

Since you've asked this also in the MS newsgroup, you might have luck that some MS supporter will become aware of it.

In the...

As Dinesh already mentioned, there is no easy way for this. See if this helps:

set nocount on

create table showme

(

 sno int not null primary key

 , c1 char default 'a'

)

insert into showme(sno,c1)...

Posted something similar yesterday. See if this helps:

USE pubs

GO

SELECT DISTINCT city

FROM authors

WHERE NOT EXISTS

   (SELECT *

   FROM publishers

   WHERE authors.city = publishers.city)

SELECT DISTINCT authors.city

FROM authors

LEFT JOIN publishers

ON authors.city = publishers.city

WHERE...

Thanks

Have a look at BOL for IF...ELSE. There is an example. If you still struggle, please post the code.

See if these help:

http://support.microsoft.com/default.aspx?scid=kb;EN-us;322988

http://support.microsoft.com/kb/216808/EN-US/

http://support.microsoft.com/kb/263712/EN-US/

Since index ID of 4 is fortunately not the clustered index on that table, have you already tried to rebuild that nonclustered index?