What are the authentication modes in sql server? How can it be changed?

0 Answers  

---

What are commit and rollback in sql?

0 Answers  

---

Difference between server.transfer and server.execute method?

2 Answers  

---

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

---

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  

---

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

---

What is the difference between local and global temporary tables?

0 Answers  

---

What happens if we shrink log file in sql server?

0 Answers  

---

How to truncate a table first before running a package?

1 Answers  

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  

---

How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,

---

How to get a list of columns in a view using the "sp_columns" stored procedure?

0 Answers  

---