How to create restore point in Server 2003?

What is a Database Snapshot ?What is Stuff function ?why we use replication .Do we use replication in an dataware house project ?What is meant by Scan and Seek ?We can use select in stored procdure using open query .Any idea .How do you do code coverage for UI and Database ? What factors are instrumental in doing UIcode coverage ? Eg : we consider Stored Procedure ,.... parameters validation as instrumental...

Hi,Someone please explain me the inner logic, how the inner query is getting executed.The Query is:SELECT t1.* FROM department t1 WHERE t1.location IN (SELECT t2.location FROM department t2 WHERE t1.dept_no t2.dept_no)The result of the Query is:dept_no dept_name locationd1 developer Seattle d2 tester Seattle...

What are the challenges you have faced while using stored procedure?