How to know the NAME of the Database and SIZE of the Database at the client nod

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

Question Posted / mk_chakri

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

Answer / neeladhar.n

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

Is This Answer Correct ?

10 Yes

0 No

More SQL Server Interview Questions

Are connections to sql server encrypted?

How to get nth highest salary from employee table.

How to use wildcard characters in like operations in ms sql server?

What is the name of the system variable that returns the number of rows affected by a SQL statement?

is there more the two primary key in a single table?

What is trigger explain with program?

What is difference between commit and rollback when used in transactions?

How do I compare two values when one value(data type) is char and the other is an integer?

Explain the xml support sql server extends?

What is the difference between truncate and delete commands?

How would we use distinct statement? What is its use?

what is database replication? : Sql server database administration

For more SQL Server Interview Questions Click Here