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

Explain sql server service broker?

980

What is report subscription?

125

How to filter out duplications in the returning rows in ms sql server?

1142

How to install sql server 2005 express edition?

1125

When to use Inner join & when to use subquery?

1166

Where views are stored in sql server?

990

What is the difference between inner join and equi join?

998

How to create a simple stored procedure in ms sql server?

1032

What are basics of policy management?

1105

why would you use sql agent? : Sql server database administration

1218

What is meant by dirty read?

996

What are triggers in ms sql server?

1167

How to drop an existing stored procedure in ms sql server?

1032

What is msdb database? : SQL Server Architecture

1137

How do use Having,Group by,Group function in SQL?

1749