How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

Answer Posted / neeladhar.n

sp_helpdb.
it will give the name & size of all the Databases.

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of nvl work?

655


your distribution database is full what will u do

1767


What is a trace frag? Where do we use it?

745


How to bind a view to the schema of the underlying tables?

663


How many partitions a clustered index has by default in sql server 2012?

745






what stored procedure can you use to display the current processes? : Sql server administration

611


List some case manipulation functions in sql?

687


What is the difference between createstatement and preparedstatement?

583


Issues related in upgrading SQL Server 2000 to 2005 / 2008

1595


What is normalization? Describe its different types.

673


if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

612


What are the properties of the transaction?

633


What is stretch database in sql server?

655


What is de-normalization in sql database administration? Give examples?

618


What are scalar functions in sql?

710