How to list all triggers in the database with sys.triggers in ms sql server?

0 Answers  

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

0 Answers  

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 Answers  

---

Explain ms sql server reporting services vs crystal reports?

0 Answers  

---

Explain cross join or cartesian product in sql?

0 Answers  

---

What is SQL Profiler and the use of it?

2 Answers   247Customer,

---

How to find the version of sql server? : sql server database administration

0 Answers  

---

Explain system scalar functions?

0 Answers  

---

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

Differences between Standby Vs No recovery?

2 Answers   Wipro,

---

How to create a store procedure with encryption?

0 Answers  

---