Answer / basha

SELECT * FROM SYSFILES, run this query against the db to
which u have to find file size.

Answer / pandian s

SELECT * FROM MSDB..BACKUPSET WHERE
Database_Name='<DatabaseName>'

Answer / rajasethupathy

The back up details would have been stored in the system
table backupset of system database msdb. So we can get it
from there.

ex

use msdb
select * from backupset

How to modify the underlying query of an existing view?

0 Answers  

---

Tell me what is the stuff and how does it differ from the replace function?

0 Answers  

---

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

---

How column data types are determined in a view?

0 Answers  

---

Can a unique index be created on a column, which contains null?

0 Answers  

---

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,

---

Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,

---

What is the importance of concurrency control?

0 Answers  

---

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

How to defragment table indexes?

0 Answers  

---

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,

---