How to change location of errorlog in SQL?

2 Answers   ABC, IBM,

---

What is exporting and importing utility?

0 Answers  

---

Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  

---

What are the different types of joins and what does each do?

2 Answers  

---

How many types of attribute relationships are there? : sql server analysis services, ssas

0 Answers  

---

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

---

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---

What is Files and Filegroups in SQL Server & it's implementation.

1 Answers   Zenith,

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

What is the difference between varchar and nvarchar types?

1 Answers  

---

Explain identity in sql server?

0 Answers  

---

What are the advantages of log shipping?

0 Answers  

---