Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

---

What is the purpose of optimization?

0 Answers  

---

How many non clustered indexes there can be on table ?

0 Answers  

---

What is scheduled job and how to create it?

0 Answers  

---

Explain triggers?

0 Answers  

---

---

I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 Answers  

---

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

---

why SQL server is more used to store database rather than Access

2 Answers  

---

What are the authentication modes in SQL Server?

4 Answers   IBM, iSmart,

---

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

0 Answers  

---

Define tempdb database?

0 Answers  

---

What is nested transaction?

0 Answers  

---