dbcc shrinkfile (dbname , targetsize)

but target size will work only upto the limit you defined for default space.

Try changing the database recovery to simple and then back to full.

Also dbcc...

is the drive where you have your userd database are alive and accessible?

Any problem with disk?

Give more information about your user database

yes, thanks for help.

It worked perfectly.

thanks for reply, but actually the data need to be updated in same table.

So lets say table a have all those data which I am able to convert using function.

But...

if you have sql server 2008 installed, then you can use activity monitor for SQL Serevr 2005 and above servers.

You can have a look of recent expensive queries

i have sql server 2008/2005 with standard edition on my laptop and its works.

Might be with lower version like express the facility is not provided......

yes, you were right.

Finally little bit modification and it did worked across all my environment.

thanks a ton for this.

lovely scripts...

but unfortunately again

substring(fil_nam,@iLen, 12) < @cDateTime comparing with date and then deciding on delete.

while I want to retain the latest 2 files, no matter since when the files...

thanks for this but xp_delete_file work based on date calculation while my requirement is based on latest available files.

For Example:-

i have a server where lot of dumps of backup file...

just few more doubt in the same task :-

What if I want to retain the latest 2 files no matter what date they are in and then delete the rest?

Can...

You will get error for those tables which are having PK reference.. .rest will be removed.

not sure but if upgrade advisor be helpful in system database

Thanks a lot. In my quick reference book now.

unfortunately, some companies still using 2000 who still not able to decide either move to 2005 or 2008....lol :-D:-D:-D:-D:-D:-D

hope you have got your answer but if not then just think a simple term....can you simply copy paste the file in your computer without downloading and saving it to...

so far we can configure in sql server to send the alert in mail. Configure the mail in your mobile and problem solved...