Thanks everyone.

I can do it now.

Thanks.... I will try it...

so after that I can just run it in one hit on to different DB, right

I try different situation and it seems to me that I can't modify the excel file manually.

originally the file is coming from the result of exporting from other apps.

so I...

Thanks Matt

Thanks

do we need to make sure no users login to DB when I increase the file manually?

thanks again

I am not really sure which DB I should add but I suspect the finance DB

the overall disk space is still about 200Gb

how do I do it?

thanks

the file doesn't open.

anyway - I solve it now by running import/export wizard through management studio.

Thanks for that.

and now I am still looking some info - how to schedule this...

Yes I run it via VS when the errors appear

I am not really sure why it can't open the file, I have permission to that folder too.

Thanks Everyone

HI,

I am running the job schedule from report manager.

I think the sql server is running too. cos in the morning I run the schedule and it is ok already.

thanks,

Susan

Thanks Jeff

Thanks for the script Jeff.

can I create this script as store proc and run it in reporting service?

I try to do it but it doesn't work

when I put

CREATE...

you are right.

last night the network was down. I think I will see what happen tonight.

the strange thing is that my schedule for re-organise index/rebuild index ( it supposed running...

Thanks Austin.

It works well 🙂

I mean the above script will produce.

Name of database

Logical file name of .MDF

.Mdf File location drive

Size of the file in MB

Physical file location(full path of .mdf file)

Maxsize

Growth

and I want...