Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sgmiller
Starting Member
2 Posts |
 Posted - 2010-09-27 : 15:29:39
|
| Hi, can someone advise how to produce a monthly report of the size of a database via email?sp_spaceused seemed to be a good TSQL to use and if I run a query with that it reports what i need.I need to get this emailed to me.I tried creating a job and it seemed to go OK but then I got bogged down in configuring the Database Mail.I wondered if I am missing a better reporting tool within SQL 2008.RgdsSteve |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sgmiller
Starting Member
2 Posts |
Posted - 2010-09-28 : 05:43:12
|
| I have the Database Mail configured and working. I have created a job and added the following command:sp_spaceusedThis however results in a job completing and emailing me but contains no data.I am guessing that I need more in the command than just the single line.I have selected the database to run the command against.Any help really appreciated.RgdsSteve |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Email database size (monthly) to user