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 parts of a function?

916

Which data type columns are the best candidates for full-text indexing?

955

How to use order by with union operators in ms sql server?

1000

Does order by actually change the order of the data in the tables or does it just change the output?

1118

What is your recommendation for a query running very slow? : sql server database administration

1025

Can an entity have two primary keys?

962

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2755

How many types of functions are there in sql server?

915

How to get a list of columns in a view using "sys.columns" in ms sql server?

974

What is indexing a document?

1020

What’s the distinction between dropping a info and taking a info offline?

1021

What happens if we shrink log file in sql server?

960

What is auditing in sql server?

912

What is merge statement?

1065

What are the difficulties faced in cube development? : sql server analysis services, ssas

1018