Answer / sreekanth

Need to do changes in the Startup Parameters
If you want to move your files you need to remove the
current entry and recreate your new entry with the correct
path. For example, To move the Master database log to
C:\test\. First delete the -l [path] by highlighting the
old parameter and choosing remove. Add the following entry,-
l C:\test\mastlog.ldf and click OK twice. Now, you will
stop SQL Server and move the mastlog.ldf to its new
location.

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

---

What can be used instead of trigger?

0 Answers   ADITI,

---

What are Sql Reporting Services and analysis services? Can u Explain

1 Answers  

---

What is sql service broker?

0 Answers  

---

What is the purpose of sql profiler in sql server?

0 Answers  

---

How to create a store procedure with encryption?

0 Answers  

---

List some case manipulation functions in sql?

0 Answers  

---

Explain view in sql server?

0 Answers  

---

How to find the login name linked to a given user name?

0 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

What is the security principal at the database level that represents your session?

0 Answers  

---

Can you name some of the dml commands in sql?

0 Answers  

---