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 divide query output into multiple groups with the group by clause in ms sql server?

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

What does executeupdate return?

0 Answers  

---

What is the difference Between Sql-server 2000 & 2005

3 Answers   Value Labs, Wipro,

---

How to check parameter value in stored procedure sql server?

0 Answers  

---

---

what is spatial nonclustered index

0 Answers  

---

What is difference between table aliases and column aliases? Do they affect performance?

0 Answers  

---

Explain rdbms?

0 Answers  

---

Explain Trigger with an example?

2 Answers  

---

What does dml stand for?

0 Answers  

---

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

0 Answers  

---

What are the main differences between #temp tables and @table variables and which one is preferred?

0 Answers  

---