is there anyway to retrieve the database properties and display in an asp.net web form as a quick over view rather than logging onto the server to check, items such as size, space available, last backup data etc?
Cheers
I have managed to get the database size using :
EXEC sp_MSforeachtable @.command1=EXEC sp_spaceused
|||
Hi,
Haven't tried it but you should be able to use theMicrosoft.SqlServer.Management.Smo to do so:
Here's an example :
http://www.aspfree.com/c/a/MS-SQL-Server/Retrieving-SQL-Server-2005-Database-Info-Using-SMO-Database-Info-Table-Info/1/
HTH,
Suprotim Agarwal
--
http://www.dotnetcurry.com
--
No comments:
Post a Comment