Explain the difference between cross join and full outer join?

0 Answers  

---

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

0 Answers  

---

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

---

Can you explain some of the DTS problems?

1 Answers   UBS, Wipro,

---

what does the automatic recovery do? : Sql server administration

0 Answers  

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

0 Answers  

---

How would you add a section to a table?

0 Answers  

---

Disadvantages of the indexes?

0 Answers  

---

What is the purpose of a table?

0 Answers  

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers   TCS,

---

What is difference between stored procedure and user defined function?

0 Answers  

---

What are trace files?

0 Answers  

---