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

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

Question Posted / neeladhar.n

Answer Posted / neeladhar.n

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

Is This Answer Correct ?

10 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1152

what is create database syntax? : Sql server database administration

1049

What are the difference between primary key and unique key? : sql server database administration

891

What is the use of nvl work?

946

What do you understand by user-defined function in the sql server?

900

Give the query of getting last two records from the table in SQL SERVER?

899

How can you find out how many rows returned in a cursor?

969

How to define the name and server for a new dsn?

1006

what data regions are and what are the different data regions?

126

How to list all triggers in the database with sys.triggers in ms sql server?

1011

What are the different subsets of sql?

1469

What is an identity?

937

How can you hide the sql server instances?

973

What is tablesample?

1023

How do I view a stored procedure in sql server?

943