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 constraints?

993

What are the advantages to use stored procedures?

1098

What is join and name different type of joins?

1040

What are acid properties of transaction?

945

What is the difference between createstatement and preparedstatement?

928

What is the fillfactor concept in indexes?

972

List out the differences between the clustered index and non-clustered index in sql server?

996

What is report rendering ?

155

Do you know what is fill factor and pad index?

996

Explain hostprotectionattribute in sql server 2005?

1007

Can a table have 2 foreign keys?

896

Do you know nested transaction?

953

What does it mean to manipulate data?

980

What is inner join? Explain with an example?

1204

Is the order of columns in the set clause important in ms sql server?

960