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...

just to add more...change it to varchar and use conversion method when you want to use it or why you putting 0 at initial if you want to make it...

just for curosity...

what about 2000? how to check the update?

if you know table name then try sp_help tablename.

then you will get all the details you want for that perticualr table....

what are the condition based on which you deciding for the data to be retained?