SQL Database Size

[bowserj]

I would like to write a script that will connect to a remote SQL server, and return the size of a specific database on that server.

I would then like to be able to write this information to a file for trend analysis. I can handle writing it to file however. I just need to know how to get the size of the remote database.

Thanks

 

[spazman]

"exec sp_databases" returns DB Name DB Size and DB Remarks

 

[FOAD123]

You'd probably need to create a new stored procedure that mimicks sp_databases (unless there is another one) that allows a parameter to be passed in, which is the database name. Otherwise you get the size of every database in that server...