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 the contrast between sql and mysql?

0 Answers  

---

How to get the definition of a trigger back?

0 Answers  

---

What are constraints?

0 Answers  

---

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

---

What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 Answers  

---

What stored by the msdb?

0 Answers  

---

What are the benefits of using stored procedures over sql statements?

3 Answers   Ness Technologies,

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

How to compare the top two records using sql?

0 Answers  

---

What is a schema in ms sql server 2005?

0 Answers  

---

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

---