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.

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

0 Answers  

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

---

Which table keeps the locking information?

0 Answers  

---

Do you know what is fill factor and pad index?

0 Answers  

---

how can ur insert the emp table

3 Answers   Wipro,

---

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  

---

Why functions are used in sql server?

0 Answers  

---

How to Generate a Series of Random Integers With T-SQL?

1 Answers  

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

What are the acid properties?

0 Answers  

---

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

0 Answers  

---

Explain fundamentals of Data ware housing & OLAP?

2 Answers  

---