What are ddl triggers and types of ddl trigger?

0 Answers  

---

What is the downside of using udf?

0 Answers  

---

When I run the sql server 2000 setup, it just hangs. What do I do?

0 Answers  

---

How to see existing views in ms sql server?

0 Answers  

---

What are the types of database recovery models?

0 Answers   HCL,

---

Why Do you want to work in this company?

4 Answers   HCL,

---

What are a scheduled jobs or what is a scheduled tasks?

0 Answers  

---

Do you know what are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

What are the different authentication modes in sql server? How can it be changed?

0 Answers  

---

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  

---

What is the tcp/ip port on which sql server runs?

0 Answers  

---

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  

---