I used this script to get the quarterly growth, but I have to modify to get the monthly growth. Can you please help.

SELECT

...

At a guess, something like this

WITH cte ([ServerName],[Database Name],[Month],[DB-Size])

AS (

SELECT [ServerName],[Database Name],DATEDIFF(month,GETDATE(),[Execution date]) AS [Month],[DB-Size]

...

Thank you so much for your help- I will try and let you know. Thanks!

I need help on quarterly growth and 1 year forcase. I created the store pro cedure with all the other information. If you can help me out in formula to...

I am asking about encrypted database restoration on same server as disaster recovery.

I am asking about the encrypted database backup. TDE is transparent database encryption.

Ok Thanks!

But it requires the sql client tool. I just want to install the sql cmd without the client tool.

Thank you so much!

I have to install sql 2005 and sql 2008 because some of the applications works only with sql 2005. we tried that by changing 90 but it didn't work. Do...

Thank you all for your response. I will try it tomorrow.

I don't want to depend on sql agent or ssis. I want to create the procedure to execute and result output should be in excell so that I can call...

Thank you so much!

I know it does give a correct result, I am trying to turn this into store procedure for daily monitoring and when I run the sp the result is printing...

I copied and pasted your script instead of typing by myself and its working. Thank you so much for your help!