Database & Log Size
-
I have several database within my instance of SQL. Periodically I need to track the size of the database and log files. Is there a stored procedure that I can use to e-mail this information to me on a scheduled basis
-
-
?? I am afraid that I don't understand what you are saying. Can you provide a little more details?
quote:
sp_helpdb with xp_sendmailSteve Jones
http://www.sqlservercentral.com/columnists/sjones
-
Please stay away from the computer, -- just kidding, unless it's production.
Sounds like you could use a consultant for a couple of weeks or so. I come highly recommended.
Any hoot, to answer your question to Steve. There's a couple of ways to do this. Try this, create a job, in step one exec sp_helpdb, under this steps options save the output to a file of your choice. In step two use xp_sendmail to mail this file as an attachment.
quote:
?? I am afraid that I don't understand what you are saying. Can you provide a little more details?quote:
sp_helpdb with xp_sendmailSteve Jones
http://www.sqlservercentral.com/columnists/sjones
John Zacharkan
John Zacharkan -
MAN! That's COLD![;(] Funny![;D] But COLD!
I was already half way there. Thanks for your help! Now I just need to find out why xp_sendmail fails.
quote:
Please stay away from the computer, -- just kidding, unless it's production.Sounds like you could use a consultant for a couple of weeks or so. I come highly recommended.
Any hoot, to answer your question to Steve. There's a couple of ways to do this. Try this, create a job, in step one exec sp_helpdb, under this steps options save the output to a file of your choice. In step two use xp_sendmail to mail this file as an attachment.
quote:
?? I am afraid that I don't understand what you are saying. Can you provide a little more details?quote:
sp_helpdb with xp_sendmailSteve Jones
http://www.sqlservercentral.com/columnists/sjones
John Zacharkan
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply