Ur welcome

You can also monitor the data packets sent across the network with the help of Netmon tool. This tool is available at sysinternals site.

its a good script and i should format it better so that everyone can understand.

will do it shortly.

Hi,

How old the file is in days......you should put a number...if its week old...then put 7.

Thanks & Regards

Azad R Sale

ohhh...now i get it.and i apologize for my ignorance.

still so much to learn.

you guys are great.taking time to answer all our questions (sometimes stupid)

how can they be reused if they r corrupt.

when we run repair command,the corrupt pages get deallocated.

it means these pages get back to the disk.

is there a possibility for these pages to come again in the database file...

so the rows present in those pages will get lost.

and if the table is huge how we will find out which rows r gone.

but the repair option deallocates pages that are corrupt....

in other words deallocate whats broken link.....

correct me if i m wrong

login using windows authentiation. and then try it

INVOLUNTARY DBA ... i guess..

HI,

it will not happen unless you have a mail server.coz it has a dedicated IP through which it sends msgs from sql server to whichever mail account.

i have tried like...

yes ,

mine was the same solution.

but q is a undocumented start-up parameter.i tried this with sql 2008.it gives me an error.i think it has been removed from sql server.

hi,

can u please sen send me ur email-id

i have purchased this tool 4 my personal use. it's a very nice tool.

i converted my 30 reports with it.

Thanks amarsale