Hi,

i want to be alerted when any of my databases is more the xxxGB.

i know one method to do that and it is with the alerts in the SQL agent Performance condition ,but with this alert when i choose to monitor on all databases the results is that i can't see the database name in the alert when i get it.

do you know a better way to achieve that ?

 Did you get ID database?

no.i don't receive any identification on what is the alert,only by the Alert name that i give when i create the alert.

Hi,

you can configure alert for specific database if it grows beyond certain size, go to SSMS->SQL Server Agent->Alert->New Alert

hth         

i know that.

but i want to monitor all databases.

You can configure an alert for the All Databases as well, or similarly you can create a job and schedule it to run daily

i don't want to create for every database an alert.

i want to create one script that will run twice a day and will check every database size.if the size i greater then 40GB then send email alert.

i start to write a script with cursor but then i was stuck with the code.

Like mentioned here http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=74&threadid=89885&enterthread=y in your post, you can put this script and write a logic to send email using a scheduled job.