Answer / amrish kumar

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

Explain Geometry datatype in sql server 2008 with example

0 Answers   Infosys,

---

Difference between group by clause and having clause in SQL?

0 Answers   Flextronics,

---

what are the advanced features in sql 2008?

2 Answers   Wipro,

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

Why foreign key column allowing null values even a parent tables reference key column not having null value..

2 Answers   IBM,

---

---

When a primary key constraint is included in a table, what other constraints does this imply?

0 Answers  

---

How to Update from select query in sql server?

0 Answers  

---

What is subquery explain with example?

0 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters

1 Answers  

---

What is a primary key?

0 Answers  

---

what are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---