Answer / debapriya

These are the three different security model connecting to
Linked Server.

In Self Mapping SQL Server tries to connect to the linked
server using current users credentials(UserId and PWD).

In Delegation SQL Server tries to connect to the Linked
server by using the Windows credential.

In Remote Credentials the Local login credential is mapped
into remote credential.

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

Can I remove the default constraint columns in SQL SERVER?

5 Answers   Value Labs,

---

what are defaults? : Sql server database administration

0 Answers  

---

What is intellisense?

0 Answers  

---

What is Replication?

0 Answers  

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---

Write a SQL query to make a column as unique?

0 Answers   Cap Gemini,

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  

---

How to optimize stored procedure optimization?

0 Answers  

---

How to defragment indexes with alter index ... Reorganize?

0 Answers  

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

0 Answers  

---

Write a code to select distinct records without using the DISTINCT keyword.

0 Answers   Aspiring Minds,

---