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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between functions and stored procedures?

793


Define Joins?

780


What are the export options of ssrs?

151


Explain the relational database management system (rdbms)?

762


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

691






what is normalization? : Sql server database administration

741


What is transaction server isolation?

748


What is meant by indexing?

663


Explain tablesample?

727


What number aggregate functions are accessible there in sql?

772


How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

933


Explain syntax for dropping triggers?

698


What do you understand by physical_only option in dbcc checkdb?

747


What is the difference between clustered index and primary key?

677


Do you know the cursor types?

839