Answer Posted / sneha daultani

By default SQL Server ERRORLOG is stored in "C:Program FilesMicrosoft SQL ServerInstanceFolderMSSQLLog" folder. The ERRORLOG location is configured as a startup parameter for SQL Server Service.

To change the location of ERRORLOG you need to modify the startup parameter -e.

Restart SQL Server Service to apply changes. 

What is self join in sql server joins?

1108

---

What is meant by datasource?

979

---

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

---

State a few properties of relational databases?

1177

---

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2847

---

Explain the properties of a relational table?

1073

---

How to select an exiting database using mssql_select_db()?

1045

---

How to disable stored procedure sql server?

1657

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

1043

---

What are the benefits and tasks of object explorer? : sql server management studio

1247

---

What are exact numeric data types in ms sql server?

1134

---

How many tables can be joined in SQL Server?

1109

---

Explain the creation and execution of a user-defined function in the sql server?

1103

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1380

---

How to find which stored procedure is currently running in sql server?

1038

---