Answer Posted / anilreddy

I am not sure but I do not think there is limit for .ndf files.As needed we can go on adding.

Determine how to use the inserted and deleted pseudo tables?

995

---

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?

1757

---

How to deploy the Report?

140

---

Explain features of analysis services?

1008

---

Where are sql server user names and passwords stored in sql server?

1098

---

What are the Advantages of using CTE in sql server?

1121

---

What is ms sql server index?

1109

---

What is sql server profiler trace data file?

1114

---

What are the lambda triggers?

916

---

What is BLOCK statements in SQL?

1268

---

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1243

---

What is sub-query in sql server?

1209

---

Write a program to fetch first 10 records from a file?

1016

---

How many types of objects are there?

1014

---

What is the difference between executequery () and executeupdate ()?

1047

---