Answer / swapna

Preferring NT authentication, using server, databse and
application roles to control access to the data, securing
the physical database files using NTFS permissions, using
an unguessable SA password, restricting physical access to
the SQL Server, renaming the Administrator account on the
SQL Server computer, disabling the Guest account, enabling
auditing, using multiprotocol encryption, setting up SSL,
setting up firewalls, isolating SQL Server from the web
server etc.

Is it important for a database administrator to understand the operating system and file access?

0 Answers  

---

List the data types available in mssql?

0 Answers  

---

How send email from database?.

3 Answers   CarrizalSoft Technologies, Merrill Lynch,

---

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

---

How get current date in SQL server 2000

4 Answers   Cap Gemini, Polaris,

---

---

What is openrowset sql server?

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 Answers   Aptech, HCL, Perpetual, SAIC,

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers  

---

What is cursor in ms sql server?

0 Answers  

---

how to dispaly a particular row details from a given table

2 Answers  

---

What is the difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  

---

How can we remove orphan records from a table?

0 Answers  

---