What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

---

How to check status of stored procedure in sql server?

0 Answers  

---

Can we insert data into a view?

0 Answers  

---

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,

---

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  

---

---

 Explain what is sql override for a source taLle in a mapping?

0 Answers   Informatica,

---

How do I start sql server agent automatically?

0 Answers  

---

What are the indexes in sql server?

0 Answers  

---

What is difference between commit and rollback when used in transactions?

0 Answers  

---

What is the purpose of a table?

0 Answers  

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

---

List out the difference between union and union all in sql server?

0 Answers  

---