Dear Chris,

!!! I Liked ur answer.

I will try to do that but i am afraid they  wont stop

Dear Jeff and RGR'us,

Thanks for ur replies.I will try ur solutions.

Regards

Killer

Dear,

If the database is not in 24*7 mode then schedule a job to backup the database and then schedule another job to restore the database on other server.

From

Killer

Dear ,

Have u scheduled the job to execute the SP and send email.

If yes then disable the job.

All problem will be solved.

From

Killer

Dear,

what is the network configuration of ur network.I mean how u are connecting to ur database through workgroup or domain.

Do u get the error at first on opening the application...

Dear all,

Thanks a lot. I am able to convince the director for stopping the shrink database process.

This is dont becaue of  ur help guys.

thanks once again.

From

Killer

Dear,

I understand what u are trying to say.But i need some strong points a part from what u described in ur posts.

So that i can explain to my directors and...

Dear ,

Thanks for the reply.But still i need to know what will be the worst part if a DBA schedule a job to shrink database after every database backup in...

Dear,

Do u want to give access to a user to backup a paticular database only or all databases.

BTW what so every . u can try as deadwood wrote or read...

dear ,

use the restore methord with move option.

For more information see BOL for move option.

from

Killer

dear,

u can read the file name and date from the disk by using xp_cmdshell.

After u get the last file name of the day upload the data into using BCP or...

Hi Jeff ,

Is it so important to write that question i am asking was asked to me in an interview..

Is this makes a diffrence in my question?

from

Killer

Dear ,

Will u post the query .Then we can help u in best way.

from

Killer

Hi Jason,

In my first post i had wrote that what i used to tranfer data from one table to other. TW i asked him not to ask "why"

When we face...

Thanks Bkelley .

from

Killer