Answer / amrish kumar

USE DataBaseName
GO
SELECT name,physical_name,size,max_size
FROM sys.master_files
WHERE database_id = DB_ID('DataBaseName');
go

What is a result set object returned by mssql_query()?

0 Answers  

---

What is a view in sql?

0 Answers  

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  

---

How to declare and use cursor variables?

0 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

How do we return a record set from a Stored Procedure in SQl server 2000?

3 Answers  

---

What are distributed partitioned views?

0 Answers  

---

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

---

How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---

What is normalization and denormalization in sql server?

0 Answers  

---

What is the difference between seek predicate and predicate?

0 Answers  

---