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 do you run a trace?

0 Answers  


what are default? Is there a column to which a default cant be bound?

1 Answers  


What is Dedicated Administrator Connection in sql server 2005?

2 Answers  


What are the types of constraints?

1 Answers  


How do SQL server 2000 and XML linked?

2 Answers  






What is filter index?

0 Answers  


What is difference between clustered and non clustered index?

0 Answers  


How can we call UDF(User Define Function) using C# code in ASP.net ?

1 Answers  


Can group by be used without aggregate functions?

0 Answers  


in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  


Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,


what is the cursor life span?

5 Answers   Evalueserve, HG,


Categories