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



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

Post New Answer

More SQL Server Interview Questions

how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,


What is a periodical index?

0 Answers  


State a few properties of relational databases?

0 Answers  


How to write a query with an inner join in ms sql server?

0 Answers  


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  






Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

0 Answers  


What is history table in sql server?

0 Answers  


What is collation sensitivity?

0 Answers  


What is the difference between system objects and user objects?

0 Answers   HCL,


What is named calculation? : sql server analysis services, ssas

0 Answers  


what is the difference between Delete and Truncate

4 Answers   CarrizalSoft Technologies, Geo Research Centre,


what is a stored procedure and trigger?

3 Answers  


Categories